Shulou(Shulou.com)05/31 Report--

This article shows you how to understand the mysql permission reference, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something.

Authorization is often involved in the daily management and application of mysql. Below, we list the references related to permissions.

1. Administrative permissions (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 permissions (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. Other permissions (Miscellaneous Privileges)

Privilege Name Operation Enabled by Privilege

ALL [PRIVILEGES] All operations (except GRANT)

USAGE A special "no privileges" privilege

4. Permission level specifier (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

The above content is how to understand the mysql permission reference, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.