How to work with users and privileges
Privileges for working with data
Privileges for modifying the database structure
Other privileges
The four privilege levels
Description
- The first group of privileges allows the user to work with the data that’s stored in the tables of the database.
- The second group of privileges allows the user to modify the structure of the database.
- MySQL makes it possible to specify privileges at the global level, the database level, the table level, and the column level.
- For a complete list of privileges, search for “privileges provided” in the MySQL Reference Manual that’s available online.
Back