Navigate not connected to centos7+mariadb problem

A problem was encountered when linking the database. Mac navicat link times wrong can ' t connect to MySQL server on ' xx.xx.xx.xx ' (61).

PS. Win version Navicat error can ' t connect to MySQL server on ' xx.xx.xx.xx ' (10038)

Where xx.xx.xx.xx is the IP address.

1. See if the user has remote login permissions

Select Host,user from Mysql.user;

Dbuser is allowed to log on from other servers.

2. Check if MySQL Server is listening on port 3306

===

Execute command

NETSTAT-LNP |grep MySQL

If there is no 3306 port listening or just listening localhost (0.0.0.0 is listening for all), my.cnf add the following line

Bind-address = 0.0.0.0

3. If the server is CentOS7, add the MySQL service to the firewall

===

Execute command

Firewall-cmd--zone=public--permanent--add-service=mysql

Returns success. And then continue to execute

Systemctl Restart Firewalld

My reboot firewall will be able to access it normally.

Navigate not connected to centos7+mariadb problem