1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpMyAdmin / MySQL error (#1044)

Discussion in 'Database Discussions' started by Homie, Jun 4, 2006.

  1. Homie

    Homie New Member

    Joined:
    Jul 22, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    When I attempt to create a new database through phpMyAdmin, I get the following message:

    MySQL said: Documentation
    #1044 - Access denied for user: 'blahblah@localhost' to database 'blahblah_sms'

    --
    I am the owner of the server and have alreayd changed MySQL with no use.

    Perhaps someone else can shed some light on this?

    Thanks in advance.
     
  2. AndyReed

    AndyReed Active Member

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Ddi you login to PhpMyAdmin as root or as the user/owner of the DBs?
    Did you grant a permission to the user to create DBs?
     
  3. Homie

    Homie New Member

    Joined:
    Jul 22, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Dib you login to PhpMyAdmin as root or as the user/owner of the DBs?

    I logged to phpMyAdmin as the user/owner of the DBs.

    Did you grant a permission to the user to create DBs?

    Yes, he was granted permission to create DBs. If it make any difference, the user was hosted on an old server of mine where he created most of DBs, and then was transfered to a newer server where he is now having the problem.

    I double checked and he is allowed currently to create new DBs.
     
  4. Homie

    Homie New Member

    Joined:
    Jul 22, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Anyone has idea about this error? :)
     

Share This Page