Shulou(Shulou.com)06/01 Report--

Editor to share with you how to set the read and write permissions of a table in the MySQL database, I believe most people do not know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

Mysql table set read and write methods: 1, through the client operation to set read and write permissions; 2, through the command line operation to set read and write, statements such as "grant select, insert, update, delete on bond_db.* to pats@'%'".

MySQL database sets read and write permissions for a table

Set through client operation

Follow the order in the picture.

To set the user's read and write permissions to the entire database, select global privileges in the second step.

Operate through the command line

Access can be controlled at several levels through grant and revoke

1, the entire server, using grant ALL and revoke ALL

2, the whole database, using on database.*

3, feature table, using on database.table

4, specific column

5, specific stored procedures

Grant select, insert, update, delete on bond_db.* to pats@'%'

Synthesis

The client is simpler, but the command line can operate in more detail, using the client in general and the command line in special cases.

The above is all about how the MySQL database sets the read and write permissions of a table. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.