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