When using Navicat for MySQl to access the remote mysql database, an error message appears, showing "2003- Can't connect MySQL Server on 'localhost'(10038)".
The reason for this error is that the remote port 3306 is not open to the outside world.
Solution steps:
First connect to the server remotely, click "Start" - "Administrative Tools" - "Windows Firewall with Advanced Security".
Related recommendations: "Navicat for mysql graphic tutorial"
In the window that opens, select "Inbound" on the left Rules" and click "New Rule" on the right to create a new inbound rule.
Select "Port" in "Rule Type" and then next step.
Check "Specific local port", enter 3306, and then take the next step.
Check "Allow connections" and then take the next step.
Just select this step by default, then take the next step.
#Finally enter the name of the new inbound rule, fill it in casually, you can understand it yourself.
#After completion, you can see the new inbound rules in the inbound rules list.
Now when I connect to the mysql remote database locally again, I find that it can be accessed normally.
The above is the detailed content of How to solve navicat remote connection database failure 10038. For more information, please follow other related articles on the PHP Chinese website!
