如何理解mysql权限参考

本篇文章为大家展示了如何理解mysql权限参考，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。

mysql日常管理和应用工作中，大家经常会涉及到授权问题，下面，我们就列举下权限相关的参考。

1、管理权限（Administrative Privileges）

Privilege Name Operation Enabled by Privilege
CREATE USER Use high-level account-management statements
FILE Read and write files on the server host
GRANT OPTION Grant the account's privileges to other accounts
PROCESS View information about the threads executing within the server
RELOAD Reload the grant tables or flush the logs or caches
REPLICATION CLIENT Ask about master and slave server locations
REPLICATION SLAVE Act as a replication slave server
SHOW DATABASES See all database names with SHOW DATABASES
SHUTDOWN Shut down the server
SUPER Kill threads and perform other supervisory operations

2、对象权限（Object Privileges）

Privilege Name Operation Enabled by Privilege
ALTER Alter tables and indexes
ALTER ROUTINE Alter or drop stored functions and procedures
CREATE Create databases and tables
CREATE ROUTINE Create stored functions and procedures

CREATE TEMPORARY TABLES Create temporary tables using the TEMPORARY keyword
CREATE VIEW Create views
DELETE Delete rows from tables
DROP Remove databases, tables, and other objects
EVENT Create, drop, or alter events for the event scheduler
EXECUTE Execute stored functions and procedures
INDEX Create or drop indexes
INSERT Insert new rows into tables
LOCK TABLES Explicitly lock tables with LOCK TABLES statements
REFERENCES Unused (reserved for future use)
SELECT Retrieve rows from tables
SHOW VIEW See view definitions with SHOW CREATE VIEW
TRIGGER Create or drop triggers
UPDATE Modify table rows

3、其他权限（Miscellaneous Privileges）

Privilege Name Operation Enabled by Privilege
ALL [PRIVILEGES] All operations (except GRANT)
USAGE A special "no privileges" privilege

4、权限级别说明符（Privilege-Level Specifiers）

Privilege Specifier Level at Which Privileges Apply
ON *.* Global privileges:all databases, all objects in databases
ON * Global privileges if no default database has been selected; database
privileges for the default database otherwise
ON db_name.* Database privileges: all objects in the named database
ON db_name.tbl_name Table privileges: all columns in the named table
ON tbl_name Table privileges: all columns in the named table in the default database
ON
db_name.routine_name Privileges for the named routine in the named database

上述内容就是如何理解mysql权限参考，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注行业资讯频道。