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.

phpbbmyadmin lists databases not belonging to logged-in user

Discussion in 'General Discussion' started by fuzzymonkey, Sep 21, 2005.

  1. fuzzymonkey

    fuzzymonkey Well-Known Member

    Joined:
    Jun 11, 2004
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    phpmyadmin lists databases not belonging to logged-in user

    On the upgrade to 10.8.0-STABLE 15, mysql v. 4.0.25-standard, phpMyAdmin shows all databases on the server, not just those the logged-in user has permission to access.
     
    #1 fuzzymonkey, Sep 21, 2005
    Last edited: Sep 21, 2005
  2. OpperGoeroe

    OpperGoeroe Active Member

    Joined:
    Apr 26, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    16
  3. ChemicalWH

    ChemicalWH Active Member

    Joined:
    Mar 4, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    same problem here, anyone find a solution to fix this already?
     
  4. ChemicalWH

    ChemicalWH Active Member

    Joined:
    Mar 4, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    try the command


    /usr/bin/mysql_fix_privilege_tables


    fixed it for me ;)
     
  5. ChemicalWH

    ChemicalWH Active Member

    Joined:
    Mar 4, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    The problem actually came back after what i posted before. the same thing would not solve it again.

    i found the following solution somewhere else:

    in mysql mode, run:

    UPDATE mysql.user SET Lock_tables_priv = 'N', Create_tmp_table_priv = 'N' WHERE
    User != 'root'; FLUSH PRIVILEGES;

    This solved it for me.
     
  6. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    You could also give
    /scripts/cleanupmysqlprivs
    a shot.
     

Share This Page