Disable access for database

Question

I created a MySQL server. Now the user login has access to all databases. I want this user not to have access (so can't do anything) to 3 databases:

• information_schema
• mysql
• phpmyadmin

So the user can use all databases except these 3. How can I get this done?

Answer 1

A brief version of how to do this (which is mostly explained in the link I posted above):

• You need to REVOKE that user's GLOBAL privileges - this is because MySQL's privilege system is top-down. If they have a GLOBAL privilege to SELECT then that applies to all of your databases
• You then need to GRANT the correct privileges on the ones it does need access to (you can use wildcards for this)

It's important to note that MySQL does not have any concept of a "DENY" privilege.