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

What this article shares to you is about the database grant authorization commands, the editor feels very practical, so share with you to learn, I hope you can learn something after reading this article, say no more, follow the editor to have a look.

Commands and permissions:

Usage does not have permission

SELECT query table record

INSERT insert table record

UPDATE updates table records

DELETE deletes table records

CREATE creates libraries and tables

DROP deletes libraries and tables

RELOAD has reload authorization and must have reload permission to execute flush [tables | logs | privileges]

SHUTDOWN allows the shutdown of mysql services to use mysqladmin shutdown to shut down mysql

PROCESS allows you to view the process of a user logging in to the database server (show processlist;)

FILE imports and exports data

REFERENCES creates a foreign key

INDEX creates an index

ALTER modifies the table structure

SHOW DATABASES View Library

SUPER shuts down threads that belong to any user

CREATE TEMPORARY TABLES allows the use of the TEMPORARY keyword in create table statements

LOCK TABLES allows the use of LOCK TABLES statements

EXECUTE executes existing Functions,Procedures

REPLICATION SLAVE reads binary logs from the primary server

REPLICATION CLIENT allows the use of show status commands on the master / slave database server

CREATE VIEW creates a view

SHOW VIEW View View

CREATE ROUTINE creates stored procedures

ALTER ROUTINE modify stored procedure

CREATE USER create user

EVENT has permission to manipulate events

TRIGGER, with permission to manipulate triggers

CREATE TABLESPACE has permission to create tablespaces

The above are the authorized commands of the database grant, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please 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.