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.

Mysql Problem

Discussion in 'General Discussion' started by procam, Sep 20, 2005.

  1. procam

    procam Well-Known Member

    Joined:
    Nov 24, 2003
    Messages:
    123
    Likes Received:
    0
    Trophy Points:
    16
    WHM 10.6.0 cPanel 10.8.0-S15
    Fedora i686 - WHM X v3.1.0

    How is it that if you login as a reg user you can view every mysql database on the server - you cannot access the data in them but nonetheless you can see they are there ~

    Is there someway to prevent regular users from seeing every db on the server???? :confused:

    The only differences I can find is this":

    use mysql;
    show tables;
    select * from user where User regexp 'russ';
    select * from user where User regexp 'cisonlin';
    select * from user where User regexp 'allen';

    the " Create_tmp_table_priv | Lock_tables_priv |" variables.

    For allen they are both |N |N
    While for russ and cisonlin they are |Y |Y

    User allen cannot view all databases server wide - while the other two can......

    Can someone please advise me on this...


    Turns out cpanel sent me the following and it did correct the problem so if you have an issue with users being able to see every database on your server youll wanna cover your bootay with this one~!

    This is an issue with the default user privileges, and this can be corrected by running the following commands against the mysql db:

    UPDATE user SET Lock_tables_priv = 'N', Create_tmp_table_priv = 'N' WHERE User != 'root';
    FLUSH PRIVILEGES;
     
    #1 procam, Sep 20, 2005
    Last edited: Sep 21, 2005
Loading...

Share This Page