mysql 5.7.42 开启远程连接

1.开启远程

mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

2.刷新权限 mysql> FLUSH PRIVILEGES;

mysql查看权限

use mysql;

select Host,User from user;

设置完查看防火墙端口有没有开启