1.创建新用户

create user ‘yueya’@’%’ identified by ‘YUEya*123456’;

2.授予权限

grant all privileges on *.* to ‘yueya’@’%’;

3.刷新权限

flush privileges;