无法链接远程数据库
1.修改root 的host 将localhost改为%
# 切换数据库
use mysql;
update mysql.user set host = '%' where user = 'root';
2.配置安全组
开启3306端口
3.防火墙配置
# 检查状态
systemctl stauts firewalld.service
# 其余还有 开始,重启等
systemctl start firewalld.service
systemctl restart firewalld.service
# 开机自启动
systemctl enable firewalld.service
#配置防火墙
firewall-cmd --zone=public --add-port=3306/tcp --permanent
systemctl restart firewalld.service
firewall-cmd --query-port=3306/tcp # 检查是否ok