MySQL launches the 1053 error resolution

  • 2020-05-14 05:02:32
  • OfStack

Operating system: windows7
mysql version: 5.5.22
www.ofstack.com
The system creates the mysql service using the command mysqld --install servicename -- defaults-file ='file_name'
The service was prompted to create successfully, but the net start command prompted a startup failure and a 1053 error was prompted in services.msc

Solutions:
Some people on the Internet say that the "login" option for the service will be set to administrator;
Others say you need to delete the service first, and then recreate it (think of both first).

However, it was found that it did not work after trying, and after inspection, it was found that it was caused by the mysqld --install command, which was the main reason
The thing is -- defaults-file doesn't point to a path in single quotes, it points to a path in double quotes but anyway, replace single quotes with double quotes, problem solved.

It is not easy to be a professional webmaster. When I saw the service card, I did not think of the failure of MYSQL.
MYSQL 1053 error resolution:
Used on the DOS command line
Step 1:
mysqld-nt remove mysqlservice
Uninstall the service, which indicates successful uninstall,
Step 2:
mysqld-nt install mysqlservice
Re-register service, 1 cut back to normal.
(can also show success in English)
Step 3:
Open the service > > > > Disable MYSQL > > > > Restart MYSQL
Will be OK
This article is the result of my own processing, when to commemorate the service for the future, perhaps online friends will encounter such a problem!
Do stationmaster so long since, really learned a lot of things... .
Service configuration, MYSQL, IIS, etc. Series 1 issues... This here tells is about to want to become the professional stationmaster friend, this road is really not good to walk... .
But if you like, you can learn a lot... Including: website production, image processing, website optimization, and many, many more... .


Related articles: