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 .

    file

    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  
    

    file

    It would look like this:
    file

    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.

    file

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

    mysql -u root -pNEWPASSWORD  
    

    file

    file

    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  
    

    file

    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  
    

    file

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

    You can now open PhpMyAdmin and log in.

    file


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