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!

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:
    156
    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:
    166
  3. ChemicalWH

    ChemicalWH Active Member

    Joined:
    Mar 4, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    156
    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:
    156
    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:
    156
    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:
    191
    You could also give
    /scripts/cleanupmysqlprivs
    a shot.
     
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