MySQL Root Password Reset, Now Cannot Connect to Database

turkey3 · Post by **turkey3** » Sat Nov 22, 2014 5:48 pm

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:

Code: Select all

Error: Connection Failed

Could changing the password have messed up other things?

zeusking19 · Post by **zeusking19** » Sat Nov 22, 2014 5:54 pm

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

turkey3 · Post by **turkey3** » Sat Nov 22, 2014 5:57 pm

Nevermind, I found out that if you change the MySQL password you also need to change it in /usr/local/vesta/conf/mysql.conf

Karrahahu1 · Post by **Karrahahu1** » Thu Feb 04, 2016 10:10 am

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

Post by **tjebbeke** » Thu Feb 04, 2016 7:07 pm

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

Vesta Control Panel - Forum