查询用户权限:
select * from mysql.user where user='username'\G
授予用户权限:
grant all privileges on *.* to 'username'@'localhost' identified by 'password';
查看MYSQL数据库中所有用户:
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
查看user表结构 需要具体的项可结合表结构来查询:
desc mysql.user;