mysql用户权限管理

参考文章：http://www.cnblogs.com/jackruicao/p/6068821.html?utm_source=itdadao&utm_medium=referral

(1)添加用户

create user zouke1220;

(2)查看用户权限

select User,Host from mysql.user;

(3)给用户赋权

update mysql.user set Host='%' where User='zouke';

grant all on *.* to 'zouke'@'%';

grant all on *.* to admin@2.48.203.38;

(4)修改登陆用户密码

update mysql.user set authentication_string=password('********') where user='zouke' and Host='%';

(5)删除用户

use mysql;

select * from user;

delete from user where User='zz';

(6)刷新权限

flush privileges;

 

连接虚拟机mysql方法:https://www.cnblogs.com/blogforly/p/5997553.html