开放 Mysql 8 数据库远程连接权限

1. 进入 Mysql 控制台

mysql -u root -p

2. 开放 Mysql 数据库远程链接权限

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

MySQL 8 上面的命令会报错:
ERROR 1410 (42000): You are not allowed to create a user with GRANT

需要用下面的命令:

112.98.125.254 是在初始链接失败的时候出现的 IP

CREATE USER 'root'@'112.98.125.254' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'112.98.125.254'WITH GRANT OPTION;

3. 保存 Mysql 数据库远程链接权限

FLUSH PRIVILEGES;

4. 查看 Mysql 数据库远程链接权限

use mysql;
select host, user from user;