高华

摘要： 查看用户权限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'; 阅读全文