How to hide information_schema & allow direct access to MySQL via 3306

Discussion in 'Installation/Configuration' started by jcw007, Nov 1, 2006.

  1. jcw007

    jcw007 New Member

    Hi all, a ISPConfig newbie here. First of all, I wanna thank all those who help make this forum a great place for finding answers to all things regarding Linux. I have personally learned quite a bit from reading threads here, and I hope to learn a great more so that I can begin to contribute to this place as well. Good works all!

    Here are my questions, and any advice is much appreciated:

    I have ISPConfig set up behind IPCop. I have installed PhpMyAdmin and created users (ie, web1_u1, so on) and databases for those users.

    (1) How to I hide the "information_schema" from users (ie, like web1_u1) in the left-hand side drop-down menu inside PhpMyAdmin? I have tried editting /home/admispconfig/ispconfig/web/phpmyadmin/ by inserting the following line for $i = 1:

    $cfg['Servers'][$i]['hide_db'] = 'information_schema';

    Then I restarted MySQL, only to find out that line apparently does not have any effect on the drop-down menu.

    Then I changed $cfg['Servers'][$i]['only_db'] = ''; to $cfg['Servers'][$i]['only_db'] = 'web%'; That seems to work; it hides every database whose name does not begin with "web". But it does that too when you log in as root. Initially database "mysql" and "db_ispconfig" are also hidden from users, so I am sure there must be a place where I can add "information_schema" to that list of hidden db. Does anyone know where that place is?

    (2) I use Phpmaker and was trying to connect to my MySQL database behind IPCop (port 3306 forwarded) from an outside IP. That didn't work no matter what I did. My question is: port 3306 should be open by default after I installed ISPConfig, right? Now it looks like the only way to manipulate my databases (other than thru terminal) is thru PhpMyAdmin, which is ok to me, just I am paranoid about something not working when I think it's supposed to.:D

    Thanks in advance!!!
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    2). Did you enable the outside access in ISPconfig where you entered the DB password as you created the mysql database?

    If you already enabled this, please post the output of:

    netstat -tap


    iptables -L
  3. jcw007

    jcw007 New Member

    DUH! How did I miss that "Remote Access" check box when creating user account!? Till, thanks for the hint!

    As for hiding "information_schema", I think I am just gonna leave it like that (with $cfg['Servers'][$i]['only_db'] = 'web%'; ) for now.
  4. tedeu

    tedeu New Member

    I want to know how to hide

    I really want to know how to hide information schema from the users ...
    And one more thing ...
    To all users there is a table in plus, a table called test, on witch they all have access.
    For example i have test user 1 and test user 2.
    I login on test user 1 and i write something in the test table, then i log out and login with User 2 and when i go to test table, i can read the recordings i made with test user 1.

    What to do with these 2 problems please ...
    Thank you verry mutch !
  5. falko

    falko Super Moderator ISPConfig Developer

Share This Page