帮助中心 >  技术知识库 >  数据库 >  数据库管理 >  MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode

MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode

2017-12-26 23:08:45 18827

实验倒腾mysql数据库,后来发现服务无法启动,查看日志报错如下:


2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode
2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writable!
2015-01-07 17:48:54 9136 [ERROR] Plugin 'InnoDB' init function returned error.
2015-01-07 17:48:54 9136 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-01-07 17:48:54 9136 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-01-07 17:48:54 9136 [ERROR] Aborting


解决方法:

1、打开任务管理器终止mysqld进程;

2、打开mysql安装目录的data文件夹,删除以下2个文件:


ib_logfile0和ib_logfile1



3、重新启动mysql


提交成功!非常感谢您的反馈,我们会继续努力做到更好!

这条文档是否有帮助解决问题?

非常抱歉未能帮助到您。为了给您提供更好的服务,我们很需要您进一步的反馈信息:

在文档使用中是否遇到以下问题: