Navicat 连接不上 Linux上的Mysql

1、连接到mysql服务器

mysql -uroot -p123456 //123456为mysql数据库下root用户的密码

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; //youpassword为mysql数据库下root用户的密码

mysql> FLUSH PRIVILEGES;


mysql> \q //退出mysql数据库

2、关闭防火墙

[root@localhost ddc]# service firewalld stop
Redirecting to /bin/systemctl stop  firewalld.service
[root@localhost ddc]# chkconfig firewalld off
Note: Forwarding request to 'systemctl disable firewalld.service'.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
Removed symlink /etc/systemd/system/basic.target.wants/firewalld.service.

3、使用navicat连接测试