Why does a new mysql user have access to information_schema in phpmyadmin?

[talitor]

I created a new user in mysql via the command line. When I use SHOW GRANTS it just says GRANT USAGE ON *.*, but when I log onto phpmyadmin with the new user, I can view everything in the information_schema database. Shouldn't that be blocked as well?

 

[Richard G]

No that's normal.

 

[talitor]

Oh interesting. What if you didn't want to give access to any of that?

 

[Richard G]

I don't see any reason why you would restrict that. As far as I now that isn't even possible. I've read on DA here somebody succeeded to hide it from view, but not from accessibility.

But it seems even not to be a real database and it's needed according to what I found here and was upvoted most as best answer.

MYSQL restrict user access to information_schema

I have a MySQL server (Server version: 5.1.68-community; MySQL client version: 5.0.51a). Is there any way to restrict ALL access to information_schema for all users? What happens is that, some cu...

stackoverflow.com

 

[talitor]

Oh, that makes sense, then. I hadn't realized it only contained information specific to the logged in user.