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.

User can log into phpMyAdmin and see all databases on server?

Discussion in 'Database Discussions' started by Jeff75, Nov 2, 2005.

  1. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
    I have a user who informed me they could see all the databases on the server when logging into phpMyAdmin. He sent me his main account login and password and I have verified this. Is there anyway make it so they can only see their databases?
     
  2. Ali Hamad

    Ali Hamad Member

    Joined:
    May 22, 2005
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Jeff :

    you have to add 'safe-show-database' to your mysql config file '/etc/my.cnf' :

    vi /etc/my.cnf

    then add :
    safe-show-database

    finally restart mysql :

    /etc/init.d/mysql restart
    myslqadmin reload

    Regards,
     
  3. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
    I tried what you said to do but unfortunately all the databases are still showing up even after restarting mysql. I've tried it using different browsers and have logged out and logged back in.

    Any other ideas?
     
  4. SonServers

    SonServers Well-Known Member

    Joined:
    Oct 24, 2001
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    I had the same thing after the latest stable upgrade.

    I found in another thread here to run:
    /scripts/cleanupmysqlprivs

    and that fixed it for me.
     
  5. Jeff75

    Jeff75 Well-Known Member

    Joined:
    Apr 11, 2003
    Messages:
    555
    Likes Received:
    0
    Trophy Points:
    16
    You are awesome! Thanks!
     
Loading...

Share This Page