cPanel mysql backup Error 1045

MHD_MUS

• December 07, 2018 18:38

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

  • December 08, 2018 02:11

  How are you attempting to restore it exactly?

  0
• 

  MHD_MUS

  • December 08, 2018 09:08

  How are you attempting to restore it exactly?

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

  0
• 

  cPanelLauren

  • December 10, 2018 18:07

  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

  0

Please sign in to leave a comment.