The system was prompted to create the service successfully when the MySQL service was created, but the net start command prompt failed to start and a 1053 error was prompted in Services.msc
Operating system: Windows7
MySQL version: 5.5.22
Www.jb51.net
When you create a MySQL service using the command mysqld--install servicename--defaults-file= ' file_name ', the system
The creation of the service was prompted for success, but the net start command prompt failed to start and a 1053 error was prompted in Services.msc
Workaround:
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 remove the service first, re-create (can consider both aspects);
But after trying to find that does not work, after the inspection only to find that the original is still caused by the Mysqld--install command, the main reason
Is that the path pointed to by--defaults-file cannot be in single quotation marks, but in the double quotation marks, in short, the single quotation mark is replaced by double quotation marks, the problem is solved.
Do personal professional webmaster is not easy Ah, see the service a bit card, restart, did not think of MySQL failure!
MYSQL 1053 Error Resolution method:
Using the DOS command line
The first step:
Mysqld-nt Remove Mysqlservice
The way to uninstall this service, it prompts uninstall success, (is the meaning of English success)
Step Two:
Mysqld-nt Install Mysqlservice
Re-registering the service, everything is back to normal.
(will also show success in English)
Step Three:
Turn on services >>>> disable mysql>>>> and start MySQL
It's OK.
This article is my own processing results, as a souvenir for the future service, perhaps online friends will also encounter such problems!
Do stationmaster so long time, really learned a lot of things ....
Service configuration, Mysql,iis and so on a series of problems ..... This here tells the upcoming to become a professional webmaster friends, this road is really not good to go .....
But if you like, you can learn a lot of things .... including: website production, image processing, website optimization, there are many ...
MySQL Startup 1053 Error resolution