Shulou(Shulou.com)05/31 Report--

This article is about what to do with 10061 unknown failures when connecting to a remote linux mysql database using navicat. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

10061 unknown failure occurred when using navicat to connect to remote linux mysql database, and 2013 failure occurred after setting ssh connection

Native 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 report error is as follows:

Solution:

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

two。 Add a # comment before the bind-address=127.0.0.1, or delete the line directly

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

At this point, use navicat to reconnect and show success.

Cause of failure: by default, Mysql does not allow access to hosts other than the local machine (except SSH). Modifying the mysqld.cnf file can solve the problem, but modifying the file may lead to security problems, so it is recommended to configure ufw firewall.

Thank you for reading! About "using navicat to connect to a remote linux mysql database in 10061 unknown failure" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.