查看

mysql> show grants for blog@'%';
GRANT USAGE ON *.* TO 'blog'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `myblog`.* TO 'blog'@'%'

收回

mysql> revoke all privileges on *.* from root@'%';
Query OK, 0 rows affected (0.18 sec)

在将权限授给指定主机的用户时,主机名必须存在于 /etc/hosts文件

 

 posted on   ChaseForFuture  阅读(123)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示