====== 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")
==== 1. Add the new mysql root user ====
<code>
# mysql -u root -p -e "GRANT ALL PRIVILEGES ON *.* TO 'ispcproot'@'localhost' IDENTIFIED BY 'verygoodpassword' WITH GRANT OPTION;"
</code>
==== 2. Open the ispcp.conf ====
<code>
# vi /etc/ispcp/ispcp.conf
</code>
==== 3. Search the right line and change the username to the new user: ====
<code>
DATABASE_USER = ispcproot
</code>
Change ispcp db password
==== 4. Open the ispcp.conf ====
<code>
# vi /etc/ispcp/ispcp.conf
</code>
==== 5. Delete your MySQL Password in the Config about line 92 like this: ====
<code>
DATABASE_PASSWORD = 
</code>
==== 6. Start the ispcp-db-passwd Script ====

<code>
/var/www/ispcp/engine/ispcp-db-passwd
</code>
Now type your new MySQL root Password
<code>
Please Enter Your New Database Password:
Please Repeat Your New Database Password:
Database Password Updated Successfully!
</code>
==== 7. That´s it! ====
Now the GUI should work again.