How to give users all kinds of permissions in mysql

In this issue, the editor will bring you about how to give users various permissions in mysql. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Mysql > grant permission 1, permission 2, … Permission n on name. Table name to user name @ user address identified by 'connection password'

Permission 1, permission 2,... Permission n represents 14 permissions such as select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file.

When permission 1, permission 2,... Permission n is replaced by all privileges or all, which means that the user is given full permissions.

When the database name. The table name is replaced by *. *, which gives the user permission to manipulate all tables in all databases on the server.

The user address can be localhost, ip address, machine name, domain name. You can also use'% to indicate a connection from any address.

The connection password cannot be empty, otherwise the creation fails.

> grant select,insert,update,delete,create,drop on vtdc.employee to identified by '123

Assign the user weijunping from 172.16.10.1 the right to select,insert,update,delete,create,drop and other operations on the employee table of the database vtdc, and set the password to 123.

The above is how to give users various permissions in the mysql that Xiaobian shared with you. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.