MySQL的授权和授权

MySQL的授权和授权

查看MYSQL数据库中所有用户
mysql> SELECT DISTINCT CONCAT(‘User: ‘’’,user,’’’@’’’,host,’’’;’) AS query FROM mysql.user;

查看数据库中具体某个用户的权限
mysql> show grants for ‘ambari’@’%’;
赋予普通用户授权权限
GRANT ALL PRIVILEGES ON . TO ‘devops’@’%’ WITH GRANT OPTION；

#收回权限(不包含赋权权限)
REVOKE ALL PRIVILEGES ON . FROM devops;

REVOKE ALL PRIVILEGES ON devops.* FROM devops;

#收回赋权权限
REVOKE GRANT OPTION ON . FROM devops;

#重新载入赋权表
FLUSH PRIVILEGES;