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 shows ALL databases

Discussion in 'Database Discussions' started by bluepine, Mar 4, 2005.

  1. bluepine

    bluepine Active Member

    Joined:
    Dec 17, 2001
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Hi all,
    I have a problem with a server with WHM 9.9.9. Since I upgraded MySQL to 4 any user can see, using phpMyAdmin, all databases on the server even if they dont belong to him.

    I tried updating WHM and all the system software, server software and backend scripts with no luck.

    Has anybody an idea on how to fix this?

    Thanks in advance

    Stefano
     
  2. germanette

    germanette Active Member

    Joined:
    Jul 26, 2003
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    It should only show all databases to superusers, did you check the users' privileges?
     
  3. bluepine

    bluepine Active Member

    Joined:
    Dec 17, 2001
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Resolved

    Thanks for your reply. Before actually checking here I upgraded WHM/CPanel to current release (it was configured to use the stable one) and it upgraded MySQL correctly. Now everything works.

    Stefano
     
  4. Alexandre Duran

    Alexandre Duran Well-Known Member

    Joined:
    May 6, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Rio de Janeiro - BRAZIL
    Just for info, put this in your /etc/my.cnf, in [mysqld]:

    safe-show-database

    Save and restart mysql.
     
Loading...

Share This Page