current position:Home>What are the MySQL permission tables?

What are the MySQL permission tables?

2022-02-04 16:48:24 Alibaba cloud Q & A

mysql What are the permission tables ?




Take the answer 1:

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 .


copyright notice
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/02/202202041648232063.html

Random recommended