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: No Privileges

Discussion in 'Database Discussion' started by Dragon-Knight, Dec 15, 2004.

  1. Dragon-Knight

    Dragon-Knight Member

    Joined:
    Jul 20, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    Hi there,

    My phpMyAdmin is 2.60 pl3. Just few days go back, I cannot do create/edit/upload databases there. Only showing No Privileges at homepage. What can I do for it?

    Rgds,
    Sam
     
  2. khaled

    khaled Member

    Joined:
    Sep 30, 2002
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    151
    reset this account passwd from whm and try again!

    Regards,
    K
     
  3. akhthar

    akhthar Member

    Joined:
    May 4, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    bangalore
    Hello Sam,

    Run the following command till the no prevlige error to be removed

    mysql_fix_privilege_tables
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Dragon-Knight

    Dragon-Knight Member

    Joined:
    Jul 20, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    thnkx

    thnkx buddies, i will try it out.
     
  5. Dragon-Knight

    Dragon-Knight Member

    Joined:
    Jul 20, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    arghh.. akhthar,

    Thanks for your advise. But I am so lame that I don't know where to run that command. YOu mean in ssh?

    root username has full privileges

    Any username on localhost has privileges except administrator rights.

    I already reloaded privileges too. But in any phpMyAdmin of my clients, it is still showing No Privileges so no one can create database right now.

    Can anyone help me with it?

    Rgds,
    Sam
     
  6. khaled

    khaled Member

    Joined:
    Sep 30, 2002
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    151
Loading...

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.
    Dismiss Notice