参考文章: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='zouke1220';
grant all on *.* to 'zouke1220'@'%';
grant all on *.* to admin@47.88.103.38;
(4)修改登陆用户密码
update mysql.user set authentication_string=password('zouke369189') where user='zouke1220' and Host='%';
(5)删除用户
use mysql;
select * from user;
delete from user where User='zz';
(6)刷新权限
flush privileges;