Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
In case of mysql attacks, many times user extracts information from information_schema.
can i do something in mysql that can restricts user to xtracts information from information_schema while all privileges on rest database is available.
When you grant permission, you specify the database and table names that you're allowing access to. Don't give unprivileged users modification privileges to *.*, list the databases explicitly in the grants.
Required, but never shown