Mysql grants user permissions, mysql user permissions

Mysql grants user permissions, mysql user permissions

# Granting permissions
MySQL> grant permission parameter on database name. Table name to user name @ user address identified by 'user password ';

# Permission to take effect immediately
MySQL> flush privileges;

 

Permission parameter: all and all privileges, indicating that all permissions are granted to the user.

Permission parameters: select, insert, update, delete, create, drop, index, alter, grant, references, reload, shutdown, process, file, and other 14 Permissions

Database Name: *, indicating all databases

Table Name: *, indicating all tables

User name: Target User

User address: %, indicating connection from any address. It can also be localhost, IP address, machine name, domain name

User Password: it cannot be blank; otherwise, creation fails.