How to troubleshoot MySQL remote connection report 10038 error

Recently using Navicat for MySQL to access the remote MySQL database, an error occurred, showing "2003-can ' t connect MySQL Server on ' localhost ' (10038)". So desperately Baidu, finally found a solution.

Method/Step

2. 1

   Reading the wrong window first.

4. Through Baidu, finally found the reason is: remote 3306 port is not open .

   The following is a remote 3306 port open operation.

6. To connect to the server remotely, click "Start"-"Administrative Tools"-"Windows Firewall with Advanced Security".

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

10. In rule type, select port, and then next.

12. Select "Specific local Port", enter 3306, and then next.

14. Check "Allow connections" and then next.

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

18. Finally enter the new inbound rule name, fill it out, you can understand.

20. When you are finished, you can see the new inbound rules in the list of inbound rules.

22. Now, once again, when you connect to the MySQL remote database locally, you find that you have access to it properly.

    Problem solving.

24. 
    

How to troubleshoot MySQL remote connection report 10038 error