[Solved] Problem after migrating from MySQL to Percona
[Solved] Problem after migrating from MySQL to Percona
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 :
And except the backup function, everything looks good (websites are OK)
How can I solve this problem ?
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 :
But if I try to access to mysql with : "mysql -u root -p", I can connect to the database with the original root password.admin → backup failed
Can't connect to MySQL localhost
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
And except the backup function, everything looks good (websites are OK)
How can I solve this problem ?
Last edited by Spheerys on Wed Dec 30, 2015 12:38 pm, edited 1 time in total.
Re: Problem after migrating from MySQL to Percona
Change mysql root password in /usr/local/vesta/conf/mysql.conf
Re: Problem after migrating from MySQL to Percona
Thanks, that's working now :)