MySQL 10038 error solution

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 One: Turn off the firewall

1. 1

   First make it clear that you are experiencing this error when you start the MySQL service in advance (this is why the MySQL service is not open).

   One way is to turn off the firewall : computer--open Control Panel--System and security--

   Windows Firewall--turn firewall on or off

   Then shut down the firewall, click OK, restart the computer on the line.

   The following connection is the process of closing the fire-proof text (the title is LOL related, the content is to turn off the firewall):

   6lol "Server connection exception, about to exit ..." solution

   END

Method Two: Create a new rule

1. Method a simple rough, but this may make people feel that the computer is not safe (actually fortunately, closed for a few months to play LOL also did not see what, after all, antivirus software is still open).

   While method two is more difficult than the method, but the overall is very simple.

   Computer--open Control Panel--System and security--

   Windows Firewall--Advanced settings. Appear as follows: Select the inbound rule first, then click New Rule.

2. Select the rule type, then port, and click Next.

3. Enter the default port number for MySQL 3306, and then select Next.

4. Select Allow connection, then click Next.

5. Follow the default selection of 3 tick and click Next.

6. A name for your new rule (you can take it, but you have to fill it), the description can be written without writing, click Finish, so OK, in the inbound rules can also find the "3306 new rules."

7. The above steps are actually OK, the next connection to MySQL to try to find success. This is the end of all, if it is helpful to you, at hand to praise Ah, there are some ah what are excellent.

   If you have questions, you can click on the upper right of the sword Hao icon to see more experience, you can private messages, discuss together.

   。

MySQL 10038 error solution