MySQL 服务无法启动 1067错误

最新推荐文章于 2023-09-28 09:55:57 发布

黄金神衣

最新推荐文章于 2023-09-28 09:55:57 发布

阅读量1.2w

点赞数 3

分类专栏：数据库

本文链接：https://blog.csdn.net/hbxtw/article/details/10097817

版权

数据库专栏收录该内容

4 篇文章 0 订阅

订阅专栏

安装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文件。

再次启动，正常