should mysql information_schema be visible to all users?

[randyriegel]

I have a VPS with cPanel. When I add new accounts it seems like that ANY mysql user can see information_schema... is this normal and/or safe or is something messed up? I'm thinking only root should be able to have access to that DB. If this is a problem how do I go about fixing it.

[JPC-Bilal]

Hi randyriegel,

Yes, it is normal. The information_schema database provides access to the database metadata. information_schema keeps the information about all the other databases. Its actually a virtual database that provides information about the database system itself. You can query this database but you cannot modify it in any mean.

If you have any confusion or question, please feel free to open a ticket with technical support department.

[randyriegel]

Ok, that clears it up. I was just worried that there may have been some sensitive information in that DB. Thanks for reply!

Randy

[komin]

Thanks for sharing such nice information