The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error 1045 on a Restore

Discussion in 'General Discussion' started by Solokron, Sep 10, 2003.

  1. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Attempting to restore a mysql backup and receiving...

    ERROR 1045: Access denied for user: 'fluxse@localhost' (Using password: YES)

    Any ideas?

    Thanks!

    cPanel.net Support Ticket Number:
     
  2. WebNET

    WebNET Active Member

    Joined:
    Jul 21, 2003
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    USA Brooklyn NYC
    Try this

    http://www.mysql.com/doc/en/Resetting_permissions.html

    It helped me tremendously! If that doesn't work, go into WHM and reset your MYSQL root password to the same password to see if that will help.

    David K.

    cPanel.net Support Ticket Number:
     
  3. Solokron

    Solokron Well-Known Member

    Joined:
    Aug 8, 2003
    Messages:
    849
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle
    cPanel Access Level:
    DataCenter Provider
    Re: Re: Error 1045 on a Restore

    This is not a root password issue.

    Thanks though.

    cPanel.net Support Ticket Number:
     
  4. ehsan

    ehsan Well-Known Member

    Joined:
    Dec 11, 2001
    Messages:
    185
    Likes Received:
    0
    Trophy Points:
    16
    same problem here,
    if you found a fix, let us know.

    cPanel.net Support Ticket Number:
     
  5. Jemshi

    Jemshi Well-Known Member

    Joined:
    Sep 11, 2003
    Messages:
    210
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    how did you try to restore the database ?

    try this.

    mysql -u username -p databasename < file.sql

    it will then ask for password. You can also use like this.

    mysql -u username -ppassword database < file.sql

    note that there is no space b/w p and password.

    or else, if you have only root login to mysql, then you can use the same command with username root and root password ( most probably, it wont be there )
     
    #5 Jemshi, Sep 26, 2003
    Last edited: Sep 26, 2003
Loading...

Share This Page