MySQL Database permissions

1.usage Permissions

This permission can only be logged into the database, cannot perform any operations, and usage permissions cannot be recycled

2.select Permissions

This permission is a field-level permission to query the data in the table

3.insert Permissions

Permission to write Data

4.update Permissions

Used to update data in a table

5.create Permissions

This permission is a table-level permission that is used to create a table

6.create Routine Permissions

This permission is a database-level permission that has this permission to create, modify, or delete a procedure or function

7.create Temporary Tables permissions

This permission can create temporary tables

8.create User Permissions

Used to create a login user

9.alter Permissions

Permissions to modify the table structure

10.alter Routine Permissions

Permissions to modify or delete stored procedures and functions

11.

This article is from the "Days Together" blog, please be sure to keep this source http://tongcheng.blog.51cto.com/6214144/1627777

MySQL Database permissions