创建用户命令
    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 ;