解决mysql 5.6 的 ./ibdata1 can't be opened in read-write mode问题

分类:Mysql |

2015-08-19 01:12:31 6608 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode

2015-08-19 01:12:31 6608 [ERROR] InnoDB: The system tablespace must be writable!

2015-08-19 01:12:31 6608 [ERROR] Plugin 'InnoDB' init function returned error.

2015-08-19 01:12:31 6608 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2015-08-19 01:12:31 6608 [ERROR] Unknown/unsupported storage engine: InnoDB

2015-08-19 01:12:31 6608 [ERROR] Aborting


2015-08-19 01:12:31 6608 [Note] Binlog end


解决方法:

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

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


ib_logfile0和ib_logfile1



3、重新启动mysql