mysql 权限管理

最新推荐文章于 2024-11-15 16:27:37 发布

忆落

最新推荐文章于 2024-11-15 16:27:37 发布

阅读量553

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/u010156872/article/details/122603014

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

登录 mysql -u root -p
输入root用户的密码
显示所有数据库 show databases
切换到mysql数据库 use mysql;
查询所有用户权限 select user,host,select_priv,update_priv,insert_priv from user;
授予dbuser用户insert权限 grant INSERT on *.* to 'dbuser'@'localhost';

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select user,host,select_priv,update_priv,insert_priv from user;
+------------------+-----------+-------------+-------------+-------------+
| user             | host      | select_priv | update_priv | insert_priv |
+------------------+-----------+-------------+-------------+-------------+
| dbuser           | localhost | Y           | Y           | N           |
| mysql.infoschema | localhost | Y           | N           | N           |
| mysql.session    | localhost | N           | N           | N           |
| mysql.sys        | localhost | N           | N           | N           |
| root             | localhost | Y           | Y           | Y           |
+------------------+-----------+-------------+-------------+-------------+
5 rows in set (0.00 sec)

mysql> grant INSERT on *.* to 'dbuser'@'localhost';
Query OK, 0 rows affected (0.02 sec)

mysql> select user,host,select_priv,update_priv,insert_priv from user;
+------------------+-----------+-------------+-------------+-------------+
| user             | host      | select_priv | update_priv | insert_priv |
+------------------+-----------+-------------+-------------+-------------+
| dbuser           | localhost | Y           | Y           | Y           |
| mysql.infoschema | localhost | Y           | N           | N           |
| mysql.session    | localhost | N           | N           | N           |
| mysql.sys        | localhost | N           | N           | N           |
| root             | localhost | Y           | Y           | Y           |
+------------------+-----------+-------------+-------------+-------------+
5 rows in set (0.00 sec)