MySQL Startup 1053 Error resolution

Source: Internet
Author: User
Tags mysql version

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.