How to set up reading and writing in mysql table

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

Recommended: "mysql video tutorial"

MySQL database sets read and write permissions for a table

Set by client operation

Follow the order in the picture

If you want to set For the user's read and write permissions on the entire database, just select global privileges in the second step.

Through command line operation

Access permissions can be controlled at several levels through grant and revoke

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

2, the entire database, use on database.*

3, feature table, use on database.table

4, specific columns

5, specific stored procedures

grant select, insert, update, delete on bond_db.* to pats@’%’

Comprehensive

The client is simpler, but the command line can perform more detailed operations. In general, the client can be used. Use the command line in special cases.

The above is the detailed content of How to set up reading and writing in mysql table. For more information, please follow other related articles on the PHP Chinese website!