phpMyadmin

[jhoedram]

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

I'm there, and I see the password, but I try to accer with root and nothing indicated and password. Besides I see that the mysqld service is stopped.

[saosangmo]

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

[imperio]

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

No

[saosangmo]

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

No

Thank you. I feel very happy with VestaCP.

[arafatx]

Why VestaCP keep this password there? So, how do I change the root password that can be seen at /usr/local/vesta/conf/mysql.conf ?

Do I just need to edit the password in there?

[arafatx]

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

I dont have /root/.my.cnf

[skurudo]

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]

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'

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?

[skurudo]

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?

Sure, this is correct way.

[pandabb]

Thanks for this , i was able to change my root pw via phpymyadmin GUI too then manually changing or adding it to the config file. Manually changing the config file without changing the password in phpyadmin gui, does'nt work in my part.