查看数据库用户权限、删除用户权限

admin · 发表于 2018-7-6 11:21:04

购买主题本主题需向作者支付 5 金钱 才能浏览

admin · 发表于 2018-7-6 11:45:16

grant all on *.* to 'account'@'192.168.0.%' identified by 'acc430'; 某网段的地址能看见

grant ALL PRIVILEGES on hive.* to "huk"@"12.168.20.%" Identified by "QgRQUswB0";

admin · 发表于 2018-7-6 14:28:01

mysql> show grants;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

账号		自动登录	找回密码
密码			开始注册

查看数据库用户权限、删除用户权限

浏览过的版块

站长推荐 /4

admin admin 当前在线积分 16843 在线时间小时最后登录 1970-1-1 窥视卡雷达卡	发表于 2018-7-6 11:21:04 \| 显示全部楼层 \|阅读模式购买主题本主题需向作者支付 5 金钱才能浏览

	回复使用道具举报提升卡置顶卡沉默卡喧嚣卡变色卡千斤顶照妖镜