Broke MySQL root password? Topic is solved

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
mericson
Posts: 19
Joined: Thu Apr 06, 2017 12:37 am

Broke MySQL root password?

Postby mericson » Thu Apr 06, 2017 12:12 pm

Since I couldn't find the root mysql password that Vesta setup, I changed to root MySQL password manually in MySQL. Well, apparently that broke things since now I'm getting the error message "backups failed" with the following details:

Code: Select all

Can't connect to MySQL localhost
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Is there a standard way to change the MySQL root password through Vesta that I should have used?

Where can I configure the root MySQL password for Vesta now so backups work?

mericson
Posts: 19
Joined: Thu Apr 06, 2017 12:37 am

Re: Broke MySQL root password?  Topic is solved

Postby mericson » Fri Apr 07, 2017 12:21 pm

I found the answer here...

https://forum.vestacp.com/viewtopic.php?t=6336

Basically, if you change your password in MySQL, you also need to edit it in the file /usr/local/vesta/conf/mysql.conf


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 2 guests