The centos system cannot connect to the mysql client

Question:

centos7 After successfully installing mysql, test the connection service on the client Navicat, prompting 10060, as shown in the following figure:

The solution is as follows:

1. The service is not started. Check the startup port:

#netstat -nltp

Start the service: (Recommended tutorial: centos usage tutorial )

#service mysqld start

2. Turn off the firewall

Turn off the firewall:

systemctl stop firewalld.service

Disable startup:

systemctl disable firewalld.service

3. Check the configuration file my.cnf to see if it is configured Bind-address = 127.0.0.1 is set and needs to be blocked.

Recommended related video tutorials: linux video tutorial

The above is the detailed content of The centos system cannot connect to the mysql client. For more information, please follow other related articles on the PHP Chinese website!