Detailed explanation of the 10061 unknown error when using Navicat to connect to a remote Linux MySQL database

When using Navicat to connect to a remote Linux MySQL database, an unknown error 10061 occurs. After setting up the SSH connection, an error 2013 occurs.

Local environment: win10 navicat premium

MySQL database host environment: Linux version 4.15.0-42-generic (buildd@lgw01-amd64-023) (gcc version 7.3.0 (Ubuntu 7.3.0-16ubuntu3)) #45-Ubuntu SMP Thu Nov 15 19:32:57 UTC 2018

mysql Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper

The fault error is as follows:

Solution:

1. Open /etc/mysql/mysql.conf.d/mysqld.cnf file

2. Add a # comment before bind-address=127.0.0.1, or delete this line directly

3. Save and close the mysqld.cnf file, and enter service mysql restart to restart the mysql database

At this time, use navicat to reconnect and it will show success.

Cause of the problem: By default, MySQL does not allow access from hosts other than the local machine (except SSH). The problem can be solved by modifying the mysqld.cnf file, but modifying the file may cause security issues, so it is recommended to configure the ufw firewall.

The above is the detailed explanation of the 10061 unknown fault when Navicat connects to the remote Linux MySQL database. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!