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!

phpMyAdmin / MySQL error (#1044)

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

  1. Homie

    Homie Member

    Joined:
    Jul 22, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Homie, Jun 4, 2006
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    Trophy Points:
    193
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 AndyReed, Jun 4, 2006
  3. Homie

    Homie Member

    Joined:
    Jul 22, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 Homie, Jun 4, 2006
  4. Homie

    Homie Member

    Joined:
    Jul 22, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    151
    Anyone has idea about this error? :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 Homie, Jun 6, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - phpMyAdmin MySQL error
  1. SupraMario

    User mysql grant permission error + phpmyadmin blank screen

    SupraMario, Dec 11, 2017, in forum: Database Discussion
    Replies:
    10
    Views:
    1,207
    behinam
    Dec 28, 2017
  2. fahl

    SOLVED Phpmyadmin mysql error

    fahl, Apr 13, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    6,235
    fahl
    Apr 14, 2017
  3. sinai

    Hide Remote MySql server IP address in phpmyadmin

    sinai, Jan 30, 2018, in forum: Security
    Replies:
    5
    Views:
    384
    cPanelMichael
    Feb 13, 2018
  4. kwdamp

    PHP version for Mysql (phpmyadmin)

    kwdamp, Jan 23, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    1,081
    cPanelMichael
    Jan 25, 2018
  5. linux.system25

    [case CPANEL-9751] Phpmyadmin - PHP MySQL library version

    linux.system25, Apr 11, 2017, in forum: Database Discussion
    Replies:
    12
    Views:
    6,078
    cPanelMichael
    May 29, 2017

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.
    Accept Learn More...
    Dismiss Notice