We are starting CHRISTMAS Sale. Get 30% OFF on lifetime licenses with code: FYSKK72

MySQL Root Password Reset, Now Cannot Connect to Database

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
turkey3
Posts: 75
Joined: Tue Aug 19, 2014 6:59 pm

MySQL Root Password Reset, Now Cannot Connect to Database

Postby 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
Posts: 1
Joined: Sat Aug 30, 2014 8:31 am

Re: MySQL Root Password Reset, Now Cannot Connect to Databas

Postby 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
Posts: 75
Joined: Tue Aug 19, 2014 6:59 pm

Re: MySQL Root Password Reset, Now Cannot Connect to Databas

Postby 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
Posts: 1
Joined: Thu Feb 04, 2016 10:09 am

Re: MySQL Root Password Reset, Now Cannot Connect to Database

Postby 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
Last edited by Karrahahu1 on Tue Feb 09, 2016 9:35 am, edited 1 time in total.

tjebbeke
Collaborator
Posts: 757
Joined: Mon May 11, 2015 8:43 am
Contact:

Re: MySQL Root Password Reset, Now Cannot Connect to Database

Postby 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


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 1 guest

cron