Shulou(Shulou.com)05/31 Report--

This article will explain in detail how MySQL authorizes users to manage the database. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

1. The permission of grant ordinary DBA to manage a certain MySQL database.

Grant all privileges on dbname to dba@'localhost'

The keyword "privileges" can be omitted.

Second, grant Advanced DBA manages the permissions of all databases in MySQL.

Grant all on *. * to dba@'localhost'

three。 Grant acts on the columns in the table:

Grant select (id, se, rank) on testdb.apache_log to dba@localhost

4. View MySQL user permissions

View current user (own) permissions:

Show grants

View additional MySQL user rights:

Show grants for dba@localhost

Revoke the permissions that have been granted to MySQL users.

The syntax of revoke is similar to that of grant, except that you can replace the keyword "to" with "from":

Grant all on *. * to dba@localhost

Revoke all on *. * from dba@localhost

Test: create a database user and grant permissions to a library

Create user 'bj'@'%' identified by' bj'

Flush privileges

Grant SELECT, INSERT,update, delete,create, drop on bjsjjh.* to 'bj'@'%' identified by' bj'

Flush privileges

This is the end of the article on "how MySQL authorizes users to manage databases". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.