[MySQL]授权

最新推荐文章于 2024-01-16 14:20:29 发布

Balmunc

最新推荐文章于 2024-01-16 14:20:29 发布

阅读量309

点赞数

分类专栏： MySQL 文章标签： mysql 授权

本文链接：https://blog.csdn.net/Balmunc/article/details/78530523

版权

MySQL 专栏收录该内容

39 篇文章 1 订阅

订阅专栏

1、查看用户权限

mysql> show grants for 'test_user'@'%';
+--------------------------------------------------------------------------+
| Grants for test_user@% |
+--------------------------------------------------------------------------+
| GRANT SELECT, CREATE TABLESPACE ON *.* TO 'test_user'@'%' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `user`.* TO 'test_user'@'%' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `book`.* TO 'test_user'@'%' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `food`.* TO 'test_user'@'%' WITH GRANT OPTION |
+--------------------------------------------------------------------------+
4 rows in set

test_user：用户名

ON后接数据库*数据表

2、授权

mysql> GRANT ALL PRIVILEGES ON `report`.* TO 'test_user'@'%';
Query OK, 0 rows affected

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected

mysql> show grants for 'test_user'@'%';
+--------------------------------------------------------------------------+
| Grants for test_user@% |
+--------------------------------------------------------------------------+
| GRANT SELECT, CREATE TABLESPACE ON *.* TO 'test_user'@'%' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `user`.* TO 'test_user'@'%' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `book`.* TO test_user'@'%' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `food`.* TO 'test_user'@'%' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `report`.* TO 'test_user'@'%' |
+--------------------------------------------------------------------------+
5 rows in set