Home > Database > Mysql Tutorial > body text

How to solve the problem of mysql server error 10038

藏色散人
Release: 2020-10-26 15:34:34
Original
7988 people have browsed it

The solution to mysql server error 10038: first check the error window; then connect to the server remotely, and click "Start->Administrative Tools->Windows Firewall with Advanced Security"; then in "Rule Type" Select "Port"; finally reopen MySql.

How to solve the problem of mysql server error 10038

Recommended: "mysql video tutorial"

Three solutions to the mysql 10038 error

##The first method:

The first step:

Look at the error window first

2003 can't connect to MySQL server on '127.0.0.1'(10038).
Copy after login

Step 2:

The reason is: the remote port 3306 is not open to external operations.

Step 3:

First connect to the server remotely, click "Start"--> "Management Tools"-->"Windows Firewall with Advanced Security".

Step 4:

In the window that opens, select "Inbound Rules" on the left and click "New Rule" on the right to create an inbound rule.

Step 5:

Select "Port" in "Rule Type" and then next step.

Step 6:

Select "Specific local connection" and enter 3306.

Step 7:

Select "Allow connection" and click Next.

Step 8:

Just select everything by default, then take the next step.

Step 9:

Give the rule a name. It can be anything, as long as you know it.

Step 10:

Just reopen MySql.

The second method:

The first step:

Open the service and see if MySql starts.

Step 2:

Start the MySql service.

The third method:

The first step:

Find the "Start" menu and open cmd.

Step 2:

Enter net start mysql.

The above is the detailed content of How to solve the problem of mysql server error 10038. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!