mysql 8.0版本与之前版本指令有所改变,下边是8.0版本指令;
1、创建用户`
create user 'username'@'%' identified by 'password';
2、赋予远程权限
grant all privileges on *.* to 'username'@'%' with grant option;
3、刷新权限
flush privileges;
4、END
mysql 8.0版本与之前版本指令有所改变,下边是8.0版本指令;
1、创建用户`
create user 'username'@'%' identified by 'password';
2、赋予远程权限
grant all privileges on *.* to 'username'@'%' with grant option;
3、刷新权限
flush privileges;
4、END