mysql常用命令

mysql>select user(); # 查看mysql的当前登录用户

mysql>select distinct concat('User:''',user,'''@''',host,''';') as query from mysql.user; # 查看mysql数据库中的所有用户

mysql>show grants for mysql@'192.168.211.133'; # 查看主机上用户权限