mysql设置远程访问处理

MySQL 8.0已经不支持下面这种命令写法
grant all privileges on *.* to root@"%" identified by ".";
模板： grant all privileges on 库名.表名 to '用户名'@'IP地址' identified by '密码' with grant option; flush privileges;

正确的写法是先创建用户
CREATE USER 'root'@'%' IDENTIFIED BY '123456!';
再给用户授权
grant all privileges on *.* to 'root'@'%' ;

flush privileges;//刷新系统权限表