Mysql adds users and grants various permissions. mysql grants permissions.

Mysql adds users and grants various permissions. mysql grants permissions.

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. For example, mysql> grant select, insert, update, delete on *. * to user1 @ "%" Identified by "123" Assign user1 to users from all addresses to select, insert, update, delete, create, drop, and set the password to 123.