开启MySQL远程连接

1、防火墙设置

关闭或者开放对应端口

firewall-cmd --add-port=3306/tcp --permanent

firewall-cmd --reload

firewall-cmd --list-all

2、修改root的host为%即可，localhost表示仅本地登录

Mysql>use mysql;

Mysql> select host,user from user;

Mysql>update user set host='%' where user='root';

Mysql>flush privileges

修改远程或者执行命令

mysql –h主机ip –u用户名 -p密码

USE mysql;

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

flush privileges;