mysql权限
来源:互联网 发布:php 端口号链接超时 编辑:程序博客网 时间:2024/03/28 21:27
1.查看数据库用户权限,默认是root@locakhostmysql> 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;
0 0
- Mysql 权限
- MySQL权限
- mysql权限
- mysql权限
- mysql 权限
- mysql 权限
- mysql 权限
- MySql权限
- MySQL权限
- mysql权限
- mysql权限
- mysql 权限
- mysql权限
- Mysql权限
- mysql权限
- mysql权限
- MYSQL权限
- mysql权限
- setTextColor
- css3的nth-child选择器的详细探讨
- LeetCode 371: Sum of Two Integers 题解
- 如何排查公司员工中黑客“内鬼”的安全隐患,妙招在此!
- ios The Simulator can't be launched because it is already in use.
- mysql权限
- 【杭电oj2063】过山车
- AlertDialog对话框
- 优秀Python学习资源收集汇总(强烈推荐)
- Apache与Nginx比较
- mysql取随机范围内地随机数
- Photo OCR
- SuperMap iObject常见问题解答集锦(九)
- Android Service之串行化Service:IntentService(系列3)