cPanel mysql backup Error 1045

MHD_MUS

Member
Jun 29, 2013
7
0
1
cPanel Access Level
Root Administrator
Hi,

I had a server running WHM with full auto backup features on.
I transferred a backup for one account to another external shared hosting running cPanel, and copied that account full backup from WHM server to the cPanel shared hosting, then extracted the backup .tar.gz on the cPanel account.

Now I am trying to restore (import) the mysql file that was in that backup file; however, it is showing error:

Code:
Error
SQL query:

-- cPanel mysql backup
GRANT USAGE ON *.* TO 'user'@'ipaddress' IDENTIFIED BY PASSWORD 'password'

MySQL said:
#1045 - Access denied for user 'anotheruser'@'localhost' (using password: YES)

Please help me restore that mysql backup file,
Regards.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,271
313
Houston
Hi @MHD_MUS


That's an odd error to be getting on a restore if the MySQL db is for the same account. Have you tried restoring through cPanel rather than PHPMyAdmin since it's a transfer from another server? cPanel>>Files>>Backup -> Restore a MySQL Database Backup