Shulou(Shulou.com)06/01 Report--

The MySQL permission table is stored in the MySQL database and initialized by the mysql_install_db script. These MySQL permission tables are "user, db, table_priv, columns_priv, proc_priv and host", respectively.

A brief introduction to the structure of the table:

"user" permission table: records user account information that is allowed to connect to the server, where permissions are at the global level.

"db" permission table: record the operation permissions of each account on each database.

"table_priv" permission table: record database table-level operation permissions.

"columns_priv" permission table: record operation permissions at the data column level.

"proc_priv" permission table: operation permissions for stored procedures and stored functions.

"host" permission table: works with the "db" permission table to exercise more detailed control over database-level operation permissions on a given host, which are not affected by "grant" and "revoke" statements.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.