Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

[Solved] Problem after migrating from MySQL to Percona

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
3 posts • Page 1 of 1
Spheerys
Posts: 225
Joined: Tue Dec 29, 2015 12:36 pm

Os: Debian 7x
Web: apache + nginx
[Solved] Problem after migrating from MySQL to Percona
  • Quote

Post by Spheerys » Tue Dec 29, 2015 12:41 pm

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 ?
Last edited by Spheerys on Wed Dec 30, 2015 12:38 pm, edited 1 time in total.
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Problem after migrating from MySQL to Percona
  • Quote

Post by skurudo » Tue Dec 29, 2015 12:52 pm

Change mysql root password in /usr/local/vesta/conf/mysql.conf
Top

Spheerys
Posts: 225
Joined: Tue Dec 29, 2015 12:36 pm

Os: Debian 7x
Web: apache + nginx
Re: Problem after migrating from MySQL to Percona
  • Quote

Post by Spheerys » Wed Dec 30, 2015 12:34 pm

Thanks, that's working now :)
Top


Post Reply
  • Print view

3 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

cron

Login  •  Register

I forgot my password