Shulou(Shulou.com)06/01 Report--

Xiaobian to share with you how to solve navicat remote connection database failure 10038 error, I hope you read this article after the harvest, let us discuss it together!

Using Navicat for MySQl to access the remote mysql database, an error appears, displaying "2003- Can't connect MySQL Server on 'localhost'(10038)."

The reason for this error is that remote port 3306 is not open to the public.

Solution steps:

First connect to the server remotely, click Start-Administrative Tools-Advanced Security Windows Firewall.

In the open window, select "Inbound Rule" on the left and click "New Rule" on the right to create a new inbound rule.

Select Port in Rule Type, and then move on.

Check "Specific local port," type 3306, and then go to the next step.

Check Allow Connections, and then move on.

This step is selected by default, and then the next step.

Finally, enter the name of the new inbound rule, fill it in casually, and you can understand it yourself.

When completed, you can see the new inbound rules in the list of inbound rules.

Now when connecting to mysql remote database locally again, I find that it can be accessed normally.

After reading this article, I believe you have a certain understanding of how to solve navicat remote connection database failure 10038 error, want to know more related knowledge, welcome to pay attention to the industry information channel, thank you for reading!

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.