How to solve the 10060 unknow error when Navicat remotely connects to MySQL

Preface: Today I want to remotely connect to MySQL on my server. The software I use is Navicat. The MySQL version on the server is 5.7

Something went wrong when I connected for the first time.

It probably means that you cannot connect to the MySQL service. The solution steps are as follows

First: First check whether your Alibaba or Tencent server console has enabled access to port 3306. For where to look, please search Baidu. Mine is as follows. You can see that remote connection is not allowed.

If you haven't enabled it like me, then enable it.

After enabling Allow all connections, try again

Another error occurred. This time, the approximate meaning is that access to this MySQL service is denied. The solution is as follows

First: Enter MySQL, select the MySQL database, and check the user=root information

As you can see, the root user is only allowed to access locally. Now you need to change it to all or specify the IP address.

I changed it to all, don't forget to flush privileges, that is, refresh the permissions, and finally try to connect remotely.

You can see that you can connect remotely.

Summary: The first step is to check whether the Alibaba or Tencent server backend is open to allow connection to port 3306

Step 2: Check whether the root user of the MySQL database table is allowed to connect remotely

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.