Operating system: Windows7
MySQL version: 5.5.22
Www.jb51.net
When using the command mysqld--install servicename--defaults-file= ' file_name ' to create a MySQL service, the system
The creation service was prompted for success, but the net start command prompted a failure and prompted a 1053 error in services.msc
Solution:
On the internet, it is said that the "Login" tab of the service is to be set up as an administrator;
It is also said that it is necessary to remove the service first, in the re-creation (you can consider these two aspects first);
But after trying to find that does not work, after the inspection found that the original or by the Mysqld--install command caused, the main reason
Is that the path that--defaults-file points to cannot be in single quotes, but in double quotes in short, replacing single quotes with double quotes solves the problem.
Do personal professional webmaster is really not easy ah, see the service is a little card, restart, did not think of MySQL invalidation!
MYSQL 1053 Error Resolution:
Use on DOS command line
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-registration service, everything back to normal.
(will also show success in English)
Step Three:
Open service >>>> disable mysql>>>> and restart 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 a problem!
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 about to want to become a professional webmaster friend, this road really difficult to go ...
But if you like, you can learn a lot of things ... including: website production, image processing, website optimization, there are many many ...