Page 1 of 1

[Solved] Problem after migrating from MySQL to Percona

Posted: Tue Dec 29, 2015 12:41 pm
by Spheerys
Hi,

I have migrate my server from MySQL to Percona by following the doc https://vestacp.com/docs/#how-to-instal ... ian-ubuntu

But during the migration, I made a mistake : at the first password asked, I just clicked on OK, leaving blank the field.
The second password asked, I put the original one (root), as wroten on the doc. I had confirmed it.

But now I have this problem : I can't make backup. I have this error message :
admin → backup failed
Can't connect to MySQL localhost
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
But if I try to access to mysql with : "mysql -u root -p", I can connect to the database with the original root password.
And except the backup function, everything looks good (websites are OK)

How can I solve this problem ?

Re: Problem after migrating from MySQL to Percona

Posted: Tue Dec 29, 2015 12:52 pm
by skurudo
Change mysql root password in /usr/local/vesta/conf/mysql.conf

Re: Problem after migrating from MySQL to Percona

Posted: Wed Dec 30, 2015 12:34 pm
by Spheerys
Thanks, that's working now :)