使用Navicat管理MySQL 1)连接报错,客户端是否能telnet mysql 的 3306 端口 systemctl status firewalld.service 查看防火墙状态 systemctl stop firewalld.service 关闭防火墙 systemctl start firewalld.service 开启防火墙 systemctl disable firewalld.service 关闭防火墙自动启动 systemctl is-enabled firewalld.service 查看防火墙开机是否启动 2)禁用防火墙后,还是无法连接,不允许连接,默认root账号只能本地登陆,不允许远程连接 use mysql; show tables; select user, host, select_priv, update_priv from user; update user set host='%' where user='root';