We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
[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 :)