What are the MySQL permission tables?

MySQL The server controls the user's access to the database through the permission table , The authority list is stored in mysql In the database , from mysql_install_db Script initialization . These authority tables are user,db,table_priv,columns_priv and host.

user Permissions on the table ： Record the user account information allowed to connect to the server , The permissions in it are global .

db Permissions on the table ： Record the operation authority of each account on each database .

table_priv Permissions on the table ： Record data table level operation authority .

columns_priv Permissions on the table ： Record the operation authority of data column level .

host Permissions on the table ： coordination db Permission table controls database level operation permission of given host more carefully . This permission table is not subject to GRANT and REVOKE Statement impact .