Mysql修改root用户可远程访问

1、登录 MySQL，修改 root 用户 Host

USE mysql;
UPDATE user SET host='%' WHERE user='root';

2、授予权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

3、刷新权限

FLUSH PRIVILEGES;

4、如果不行则查看 MySQL 配置文件确保 bind-address为0.0.0.0

5、修改好之后重启mysql服务