How to solve the 1053 error of MySQL startup bitsCN.com
Operating system: Windows 7
Mysql version: 5.5.22
Www.bitsCN.com
When you use the command mysqld -- install servicename -- defaults-file = 'File _ name' to create a mysql service, the system
The system prompts that the service is successfully created, but the net start command prompts that the startup failed, and the error 1053 is displayed in services. msc.
Solution:
Someone on the Internet said that the "login" tab of the service should be set to administrator;
Some people say that the service needs to be deleted first and re-created (you can consider these two aspects first );
However, it does not work after the test. after the check, it is found that it is still caused by the mysqld -- install Command, mainly because
The path pointed to by -- defaults-file cannot be enclosed in single quotes. Instead, it must be enclosed in double quotes to replace single quotes with double quotes. The problem is solved.
It's really not easy to be a professional Webmaster. I don't think MYSQL is invalid when I see that the service is stuck!
MYSQL 1053 error solution:
Use the doscommand line
Step 1:
Mysqld-nt remove mysqlservice
To uninstall the service, it prompts that the uninstall is successful)
Step 2:
Mysqld-nt install mysqlservice
Register the service again, and everything will return to normal.
(The English version is displayed successfully)
Step 3:
Open the service >>> disable MYSQL >>> start MYSQL again
OK.
This article is the result of my own processing. it serves as a souvenir for the future. maybe online friends may also encounter such problems!
I have learned a lot since I became a webmaster for so long ....
Service configuration, MYSQL, IIS, and so on ..... This tells us that we are about to become friends of professional Webmasters. This road is really hard to go .....
But if you like it, you can learn a lot .... Including: Website production, image processing, website optimization, and many more .....
BitsCN.com