mysql用户相关操作

创建用户

create user 'username'@'host' identified by 'password'

授权

grant privalieges on database to 'username'@'host'

 设置远程访问

grant all on *.* to 'username'@'%' identifyed by 'password' 

 回收权限

revoke privileges on database from 'username'@'host'

 删除用户

drop user 'username'@'host'