Cannot create Windows service for Mysql.error:0_mysql when troubleshooting MySQL5.1 installation

Source: Internet
Author: User
Tags mysql delete

Installation MySQL5.1 process, I have previously MySQL5.0 GUI tools and servers all deleted, installation directory all deleted, data file directory name changed, the registry with the perfect uninstall clean.
Then reboot the installation MySQL5.1 (I've had a service that I've never started before) and you can configure the cannot create Windows service for mysql.error:0 error in the final step. Turn off the configuration tool to retry a few times, then Baidu, I heard that to the system administrator users under the implementation of SC delete mysql delete mysql service after the start Configuration tool configuration, it is not a reboot after the test.
I delete the service reconfiguration is still the same error, and then delete the service, reboot after the configuration or not.
Also on the Internet to refer to a number of articles, the final solution is as follows:

1. Turn off the configuration tool after the error, execute the command under the System administrator account:sc delete mysql(MySQL is the service name, according to your service name);

2. Delete the c:/documents and Settings/all users/application data/mysql/mysql Server 5.1/data directory ib_logfile0, Ib_logfile1 Two files deleted, incidentally, this directory has a err file, is named after the hostname, which contains the error message, similar to the following paragraph:

Innodb:the the specified data file E:/data/ibdata1 did not exist:
INNODB:A new database to is created!
090501 19:20:08 innodb:setting file e:/data/ibdata1 size to MB
Innodb:database physically writes the file full:wait ...
InnoDB:Error:log file./ib_logfile0 is of different size 0 48234496 bytes
Innodb:than specified in the. cnf file 0 17825792 bytes!
090501 19:20:09 [ERROR] Plugin ' InnoDB ' init function returned ERROR.
090501 19:20:09 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE.
090501 19:20:09 [ERROR] unknown/unsupported table Type:innodb
090501 19:20:09 [ERROR] Aborting
090501 19:20:09 [Warning] forcing shutdown of 1 plugins
090501 19:20:09 [note] e:/program files/mysql/mysql server/bin/mysqld:shutdown complete

3. Delete the configuration when the specified data file directory, as if I can not immediately delete, I use unlocker delete when it said to be deleted the next time the reboot.
4. Reboot.
5. Start Configuration Tool configuration.

It was a success this time.

Thanks to the seniors who provided the information, and also to the friends who have the same mistakes.

The above is MySQL5.1 installation error solution, I hope to help you learn, but also hope that we support the cloud habitat community.

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.