ERROR : Access denied for user 'user_name'@'localhost' to database 'db_name'.....?

Discussion in 'MySQL' started by torrfriend, Sep 12, 2010.

  1. #1
    Checking the database connection ... [OK]
    ERROR : Access denied for user 'user_name'@'localhost' to database 'db_name'

    what it mean...? i always got this error...
     
    torrfriend, Sep 12, 2010 IP
  2. mjewel

    mjewel Prominent Member

    Messages:
    6,693
    Likes Received:
    514
    Best Answers:
    0
    Trophy Points:
    360
    #2
    It means the user doesn't have permission to access your mysql database. Either you haven't granted the user permission, or your user is wrong in your config settings of the program.
     
    mjewel, Sep 12, 2010 IP
  3. torrfriend

    torrfriend Active Member

    Messages:
    138
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #3
    how to grant permission to that user.....(because i have globally only one user for all my database)
     
    torrfriend, Sep 12, 2010 IP
  4. mjewel

    mjewel Prominent Member

    Messages:
    6,693
    Likes Received:
    514
    Best Answers:
    0
    Trophy Points:
    360
    #4
    If you are using cpanel, you need to add the user to each individual database.
     
    mjewel, Sep 12, 2010 IP