DB: "information schema" visible to users

4u123

Well-Known Member
PartnerNOC
Jan 2, 2006
944
28
178
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 ?
 

4u123

Well-Known Member
PartnerNOC
Jan 2, 2006
944
28
178
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

cPanel Development
Staff member
Apr 7, 2006
4,607
80
458
cPanel Access Level
Root Administrator
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

Well-Known Member
PartnerNOC
Jan 2, 2006
944
28
178
ok,

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

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
80
458
cPanel Access Level
Root Administrator
It depends upon your customer.

I use it to check the stored procedures I create.