mysql用户管理
1、新建用户
create user username@host identified by 'password';
例如：
create user root@10.110.21.31 identified by '1234';
2、删除用户
drop user username@host;
例如：
drop user root@10.110.21.31;
3、修改用户密码
alter user user() identified by 'password';
或
set password for username@host='newpassword';
例如：
alter user user() identified by '123456';
或
set password for root@10.110.21.31='123456';
4、授权
grant privileges on database.table to username@host;
例如：
grant all [privileges] on dt.* to root@10.110.21.31;
grant all on *.* to 'root'@'%';
5、撤消授权
revoke privileges on database.table from username@host;
例如：
revoke all on dt.* from root@10.110.21.31;
6、查看授权
show grants for username@host;
例如：
show grants for root@10.110.21.31;
7、刷新权限
flush privileges;
下一篇：mysql查看和修改字符集