Mysql> grant permission 1, permission 2 ,... Permission n on database name. Table name to user name @ user address identified by 'Connection password ';
Permission 1, permission 2 ,... Permission n indicates 14 permissions, including select, insert, update, delete, create, drop, index, alter, grant, references, reload, shutdown, process, and file.
When permission 1, permission 2 ,... Permission n is replaced by all privileges or all, indicating that all permissions are granted to the user.
When the database name. Table name is replaced by *. *, it grants the user the permission to operate all the tables in the database on the server.
The user address can be localhost, IP address, machine name, or domain name. You can also use '% to connect from any address.
The 'Connection password' cannot be blank; otherwise, creation fails.
Mysql> grant select, insert, update, delete, create, drop on vtdc. employee to weijunping@172.16.10.1 identified by '100;
Assign permissions for select, insert, update, delete, create, drop, and other operations to the user weijunping from 172.16.10.1 on the database's vtdc employee table, and set the password to 123.