Broke MySQL root password? Topic is solved

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
Posts: 21
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?

Posts: 21
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...

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 1 guest