创建用户命令
create user username@localhost identified by ‘password’;
直接创建用户并授权的命令
grant all on . to username@localhost identified by ‘password’;
授予外网登陆权限
grant all privileges on . to username@’%’ identified by ‘password’;
授予权限并且可以新建
grant all privileges on . to username@’hostname’ identified by ‘password’ with grant option ;