How To change the MySQL DB User and/or Password in the ispCP Config

If you only want to change the password: goto step 4.)

Change ispcp db username (eg. “root” → “ispcproot”)

# mysql -u root -p -e "GRANT ALL PRIVILEGES ON *.* TO 'ispcproot'@'localhost' IDENTIFIED BY 'verygoodpassword' WITH GRANT OPTION;"

# vi /etc/ispcp/ispcp.conf

DATABASE_USER = ispcproot

Change ispcp db password

# vi /etc/ispcp/ispcp.conf

DATABASE_PASSWORD = 

/var/www/ispcp/engine/ispcp-db-passwd

Now type your new MySQL root Password

Please Enter Your New Database Password:
Please Repeat Your New Database Password:
Database Password Updated Successfully!

Now the GUI should work again.