Page 1 of 1
MySQL Root Password Reset, Now Cannot Connect to Database
Posted: Sat Nov 22, 2014 5:48 pm
by turkey3
I reset my MySQL password because I must have forgotten it or never set one. My first question is, what is the default MySQL password for root that Vesta sets upon installation? I followed this guide
https://help.ubuntu.com/community/MysqlPasswordReset and now after changing the password I cannot connect to MySQL. The password reset worked, and I can create and manage databases through the local terminal, but creating a database in the control panel now results in:
Could changing the password have messed up other things?
Re: MySQL Root Password Reset, Now Cannot Connect to Databas
Posted: Sat Nov 22, 2014 5:54 pm
by zeusking19
Take a look in the following files to see if your root password is incorrect:
Code: Select all
/usr/local/vesta/conf/vesta.conf
/usr/local/vesta/conf/mysql.conf
Re: MySQL Root Password Reset, Now Cannot Connect to Databas
Posted: Sat Nov 22, 2014 5:57 pm
by turkey3
Nevermind, I found out that if you change the MySQL password you also need to change it in /usr/local/vesta/conf/mysql.conf
Re: MySQL Root Password Reset, Now Cannot Connect to Database
Posted: Thu Feb 04, 2016 10:10 am
by Karrahahu1
The password reset worked, and I can create and manage databases through the local terminal, but creating a database in the control panel now results in:????
[deleted]
Ali
| A stern warning from the administrator imperio | !! |
| Spam is not allowed on this forum. Next time your account will be blocked |
Re: MySQL Root Password Reset, Now Cannot Connect to Database
Posted: Thu Feb 04, 2016 7:07 pm
by tjebbeke
Karrahahu1 wrote:The password reset worked, and I can create and manage databases through the local terminal, but creating a database in the control panel now results in:????
Ali
Change root password in /usr/local/vesta/conf/mysql.conf