1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Discussion in 'MySQL Forums' started by JosephK, Aug 9, 2011.

  1. JosephK

    JosephK Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    I have another issue.

    When I try to access mysqladmin on my localhost MySQL installation (WAMP), I get the error

    #1045 - Access denied for user 'root'@'localhost' (using password: NO)

    I figured that it needs a password which it is not using. But how do I specify it to use a password?

    Many thanks for your help.
     
  2. UnixGuru

    UnixGuru Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Your mysqladmin logs in with a blank password for user root. Since this is a WAMP installation, you need to specify the password in config.inc.php file for phpmyadmin and update the user root and specify a password.