mysql权限相关
摘要:
查看用户权限show grants for root@host;授权:GRANT ALL PRIVILEGES ON *.* TO 'root'@'host' IDENTIFIED BY 'password';撤销权限:REVOKE ALL PRIVILEGES FROM root@10.11.2.174; 查看哪些用户在哪些host上有‘GRANT OPTION’权限select Host,User,Grant_priv from mysql.user where Grant_priv='Y'; 阅读全文
posted @ 2012-11-06 11:06 高华 阅读(136) 评论(0) 推荐(0) 编辑