Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to solve the mysql 1053 error problem, Xiaobian thinks it is quite practical, so share it with you for reference, I hope you can gain something after reading this article.

mysql 1053 error solution: 1, uninstall the service through the "mysqld-nt remove mysqlservice" command;2, re-register the service;3, restart MYSQL.

Operating environment: Windows 7 system, mysql 8.0.22 version, Dell G3 computer.

MySQL Startup Error 1053 Solution

When creating mysql service, the system has prompted that the service was successfully created, but the net start mysql command prompts that the startup failed and prompts 1053 error in services.msc

Solution 1:

On the Internet, some people say that the "login" tab of the service should be set to administrator;

Some people say that it is necessary to delete the service first and then recreate it (these two aspects can be considered first);

But after trying to find that it does not work, after checking it was found that the original or mysqld --install command caused, the main reason

The--defaults-file path cannot be in single quotes, but within double quotes. In short, replace single quotes with double quotes. Problem solved.

Do individual occupation stationmaster is not easy really ah, see service has dot card, restart, did not think MYSQL invalidation!

MYSQL 1053 error resolution:

Use on DOS command line

Step 1:

mysqld-nt remove mysqlservice

The way to uninstall this service, it indicates that the uninstall is successful,

Step 2:

mysqld-nt install mysqlservice

Re-register for service and everything is back to normal.

(English also shows success)

Step 3:

Open Services>>> Disable MYSQL>>>> Restart MYSQL

Then it's OK.

Solution 2:

Problems encountered:

Windows cannot start MYSQL80 service error 1053: Service did not respond to start or control request in time

1. In the last step of installing MySQL, when configuring to start MySQL service, MySQL failed to start, as follows:

2. Find MySQL80 service in My Computer-> Right-> Management-> Services and Applications-> Services, right-click to start, and report error as shown below:

3. Due to the newly installed operating system of Xiaobian, there have also been prompts of insufficient permissions before, so the fault is first located as a permission problem. Because MySQL80 service in computer management-> services shows the user category: network services. As shown below:

Methods:

1. To improve network service permissions, you need to add network services to the administrator group. The steps are as follows:

(1) Computer-> Management-> Local Users and Groups-> Group Double-click, the effect is as follows:

(2) Double-click Administrators and click Add

(3) Click Advanced

Add Network Service to Administrators group

(5) Click OK to start MYSQL80 service again without any problems or enter it on command line (administrator), as shown in the figure:

This article is brother's guidance plus my own processing results, as a memorial for future service, perhaps online friends, will also encounter such problems!

About "how to solve mysql 1053 error problem" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

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.