mysql权限

最新推荐文章于 2022-11-28 17:31:27 发布

linlemo

最新推荐文章于 2022-11-28 17:31:27 发布

阅读量180

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/linlemo/article/details/52229610

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1.查看数据库用户权限，默认是root@locakhost
mysql> show grants;      
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+

2.查看数据库某用户的权限
mysql> show grants for root@'localhost';
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+

2.授予用户在所有数据库上的所有权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.105' IDENTIFIED BY 'huawei123#';

// 所有ip都可以以这个用户名密码访问数据库
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'huawei123#';

//刷新系统权限表
mysql> flush privileges;