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!

Mysql Problem

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

  1. procam

    procam Well-Known Member

    Nov 24, 2003
    Likes Received:
    Trophy Points:
    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';
    #1 procam, Sep 20, 2005
    Last edited: Sep 21, 2005

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