How to solve the 1053 error of MySQL startup _ MySQL

Source: Internet
Author: User
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

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.