Vesta Control Panel - Forum

imperio wrote:Hi, you can find mysql root password in this files
/usr/local/vesta/conf/mysql.conf

Code: Select all

USER='root' PASSWORD=''

or

Code: Select all

/root/.my.cnf

passwords for root vps and root mysql is different

hi, should i restart some service after change password of mysql root?

imperio wrote:

hi, should i restart some service after change password of mysql root?

No

imperio wrote:Hi, you can find mysql root password in this files
/usr/local/vesta/conf/mysql.conf

Code: Select all

USER='root' PASSWORD=''

or

Code: Select all

/root/.my.cnf

passwords for root vps and root mysql is different

arafatx wrote: I dont have /root/.my.cnf

[client]
password='your-root-mysql-password'

skurudo wrote:

arafatx wrote: I dont have /root/.my.cnf

This file appear when you log to mysql console and you access to this console without password. You can create file yourself:

Code: Select all

[client]
password='your-root-mysql-password'

arafatx wrote: THank you. I solved this problem by manually changing the root password under phpmyadmin UI then I put the password at /usr/local/vesta/conf/mysql.conf . Is that the correct way?