MySQL failed to start service, MySQL card dead solution

Source: Internet
Author: User


A few days ago, the start of MySQL, suddenly reported 1067 system errors, dead and alive can not start.
No matter 3,728, reload, empty the registry, restart, still can't start.
Always in the configuration after the installation where the last step to start the service interface card dead, half a day did not respond.
Toss for two or three hours, just suddenly remembered, should go to look at the log,
110223 15:58:08 [note] Plugin ' federated ' is disabled.
110223 15:58:08 innodb:initializing buffer pool, size = 17.0M
110223 15:58:08 innodb:completed initialization of buffer pool
Innodb:no valid checkpoint found.
Innodb:if This error appears the are creating an InnoDB database,
Innodb:the problem May is that during a earlier attempt you managed
Innodb:to Create the InnoDB data files, but log file creation failed.
Innodb:if that's the case, please refer to
Innodb:http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
110223 15:58:08 [ERROR] Plugin ' InnoDB ' init function returned ERROR.
110223 15:58:08 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE.
110223 15:58:08 [ERROR] unknown/unsupported table Type:innodb
110223 15:58:08 [ERROR] Aborting
The effect is that the InnoDB initialization fails and does not recognize the InnoDB type.
Google a bit, the My.ini file open, change default-storage-engine=innodb for Default-storage-engine=myism
Started successfully. But the InnoDB engine was not found when the table was built.
But think, also can't old so ah, so InnoDB also use, have Google a bit, the main is InnoDB log size is not caused by
innodb_buffer_pool_size=512m
innodb_log_file_size=128m
The above several parameters, and then ibdata1,ib_logfile0,ib_logfile1 these three files deleted, and then restart the service is good.
If it still doesn't work, you'll need to add tmpdir= "usr/tmp" to the My.ini file because InnoDB also needs a temporary file buffer.
Also encountered the problem is that the password is correct, but the GUI tool can not log in, you may use the configuration program to modify the password, and then login at the command line to refresh permissions on it. Flush privilege.
Recorded, only for students who encounter such problems for reference.

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.