Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

cPanel mysql backup Error 1045

Discussion in 'Database Discussion' started by MHD_MUS, Dec 7, 2018.

  1. MHD_MUS

    MHD_MUS Member

    Joined:
    Jun 29, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    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.
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,945
    Likes Received:
    485
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    How are you attempting to restore it exactly?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. MHD_MUS

    MHD_MUS Member

    Joined:
    Jun 29, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I go to the new cPanel >> phpmyAdmin >> import , then import the mysql file
     
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,472
    Likes Received:
    505
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice