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/...on-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.