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.