cPanel mysql backup Error 1045

[MHD_MUS]

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:

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.

 

[Infopro]

How are you attempting to restore it exactly?

 

[MHD_MUS]

How are you attempting to restore it exactly?

I go to the new cPanel >> phpmyAdmin >> import , then import the mysql file

 

[cPanelLauren]

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