MySQL 服务无法启动 1067错误

时间:2022-07-29 17:16:11

  安装mysql-5.6.13-winx64完成后,net start mysql 启动时报错。

  查看错误信息:

 2013-08-20 09:52:28 2520 [Note] Plugin 'FEDERATED' is disabled.
2013-08-20 09:52:28 2520 [Note] InnoDB: The InnoDB memory heap is disabled
2013-08-20 09:52:28 2520 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-08-20 09:52:28 2520 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-08-20 09:52:28 2520 [Note] InnoDB: Not using CPU crc32 instructions
2013-08-20 09:52:28 2520 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-08-20 09:52:28 2520 [Note] InnoDB: Completed initialization of buffer pool
2013-08-20 09:52:28 2520 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode
2013-08-20 09:52:28 2520 [ERROR] InnoDB: The system tablespace must be writable!
2013-08-20 09:52:28 2520 [ERROR] Plugin 'InnoDB' init function returned error.
2013-08-20 09:52:28 2520 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2013-08-20 09:52:28 2520 [Warning] MySQL: unknown variable 'loose-default-character-set=utf8'
2013-08-20 09:52:28 2520 [ERROR] Unknown/unsupported storage engine: InnoDB
2013-08-20 09:52:28 2520 [ERROR] Aborting

 

在网上找各种解决方法,无法解决

正确解决方法:删除data目录下的ib_logfile0和ib_logfile1文件。

再次启动,正常