Introducing the MySQL Privilege System
The MySQL privilege system is always on. The first time you try to connect, and for each subsequent action, MySQL checks the following three things:
Where you are accessing from (your host)
Who you say you are (your username and password)
What you're allowed to do (your command privileges)
All this information is stored in the database called mysql, which is automatically created when MySQL is installed. There are several tables in the mysql database:
columns_priv— Defines user privileges for specific fields within a table
db— Defines the permissions for all databases on the server
func— Defines user-created functions
host— Defines the acceptable hosts that can connect to a specific database
tables_priv
Get Sams Teach Yourself PHP, MySQL® and Apache All in One now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
