The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpMyAdmin: No Privileges

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

  1. Dragon-Knight

    Dragon-Knight Member

    Joined:
    Jul 20, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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:
    1
    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:
    1
    Location:
    bangalore
    Hello Sam,

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

    mysql_fix_privilege_tables
     
  4. Dragon-Knight

    Dragon-Knight Member

    Joined:
    Jul 20, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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:
    1
    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:
    1
Loading...

Share This Page