DB: "information schema" visible to users

[4u123]

Hi,

Customer just told me he can see a database called "information schema" containing 17 tables in his phpmyadmin. Could anyone advise on how to fix this ?

 

[cPanelKenneth]

If you "fix" it, you'll likely break other thigns as MySQL uses that for its own purposes. You can find more information here: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

 

[4u123]

Hi Kenneth,

If its a system database of some sort then why can all my customers see it in phpmyadmin ?

Surely the "fix" would be for cpanel to ensure that such system databases cant be seen by regular users ?

 

[cPanelKenneth]

Because:

1. That database contains meta data necessary for MySQL 5 to function
2. A MySQL user can only see in that database what he actually has access to
3. It's not actually a database, but a view

 

[4u123]

ok,

Can you tell me what a customer would use it for ?

 

[cPanelKenneth]

It depends upon your customer.

I use it to check the stored procedures I create.