Information about the root password for the MySQL user in Hestia CP

Hestia CP - this is one of the most popular, simple and convenient panels for managing sites, with its help you can add new sites, work with mail and databases, Cron, updates, file manager, the ability to add SSL.

The password is stored at

/usr/local/hestia/conf/mysql.conf

To find out login and password for root access to MySQL you need to connect to the server via SSH, and open the file using a text editor, for example Nano:

nano /usr/local/hestia/conf/mysql.conf

It would look like this:

Changing the MySQL user password in Hestia CP

Use this command to change your password:

mysqladmin -u root -pOLDPASSWORD password 'NEWPASSWORD'

• OLDPASSWORD specify the real mysql root password you get from the mysql.conf file
• Replace NEWPASSWORD with the new password you want.

After that, try going back to the mysql server with root privileges, using the new password you just created:

mysql -u root -pNEWPASSWORD

Open the mysql.conf file again and replace the old password (the one created by the panel) with the new password:

nano /usr/local/hestia/conf/mysql.conf

Save your changes and exit the editor, in Nano (Ctrl+O, then Ctrl+X).

Then you need to change the old mysql password stored in my.cnf:

nano /root/.my.cnf

Save your changes and exit the editor, in Nano (Ctrl+O, then Ctrl+X).

You can now open PhpMyAdmin and log in.

---

If you have difficulty setting up or have additional questions, you can always contact our support team via ticket system.