【MySQL】权限

权限相关表

https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html

列权限

列权限只有 INSERT、UPDATE、SELECT

无效权限

有库权限，同时有库中单表权限

有表权限 INSERT、UPDATE、SELECT，同时在列上还有 INSERT、UPDATE、SELECT 权限

user

User accounts, global privileges, and other nonprivilege columns.

db

Database-level privileges.

tables_priv

Table-level privileges.

columns_priv

Column-level privileges.

procs_priv

Stored procedure and function privileges.

proxies_priv

Proxy-user privileges.

迁移用户及权限

覆盖插入

mysqldump  -n -t --replace --tables user db tables_priv columns_priv procs_priv proxies_priv

权限种类

https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html

Privilege	Grant Table Column	Context
ALL [PRIVILEGES]	Synonym for “all privileges”	Server administration
ALTER	Alter_priv	Tables
ALTER ROUTINE	Alter_routine_priv	Stored routines
CREATE	Create_priv	Databases, tables, or indexes
CREATE ROUTINE	Create_routine_priv	Stored routines
CREATE TABLESPACE	Create_tablespace_priv	Server administration
CREATE TEMPORARY TABLES	Create_tmp_table_priv	Tables
CREATE USER	Create_user_priv	Server administration
CREATE VIEW	Create_view_priv	Views
DELETE	Delete_priv	Tables
DROP	Drop_priv	Databases, tables, or views
EVENT	Event_priv	Databases
EXECUTE	Execute_priv	Stored routines
FILE	File_priv	File access on server host
GRANT OPTION	Grant_priv	Databases, tables, or stored routines
INDEX	Index_priv	Tables
INSERT	Insert_priv	Tables or columns
LOCK TABLES	Lock_tables_priv	Databases
PROCESS	Process_priv	Server administration
PROXY	See proxies_priv table	Server administration
REFERENCES	References_priv	Databases or tables
RELOAD	Reload_priv	Server administration
REPLICATION CLIENT	Repl_client_priv	Server administration
REPLICATION SLAVE	Repl_slave_priv	Server administration
SELECT	Select_priv	Tables or columns
SHOW DATABASES	Show_db_priv	Server administration
SHOW VIEW	Show_view_priv	Views
SHUTDOWN	Shutdown_priv	Server administration
SUPER	Super_priv	Server administration
TRIGGER	Trigger_priv	Tables
UPDATE	Update_priv	Tables or columns
USAGE	Synonym for “no privileges”	Server administration