mysql用户创建及授权

Mysql数据库

登录mysql

mysql -uroot -p

创建用户

create user 'testuser1'@'%' identified by '123456';

刷新权限

flush privileges;

为用户赋权

grant all privileges on test_grant.* to 'testuser1'@'%' with grant option;

查看用户权限

show grants for 'testuser1'@'%';

撤销用户权限

revoke all privileges on test_grant.* from 'testuser1'@'%';

回收用户权限

revoke all privileges,grant option from 'testuser1'@'%';

删除用户

drop user 'testuser1'@'%';

查询所有用户及权限

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

也可以这样

SELECT User, Host FROM mysql.user;