MYSQL服務無法啟動：InnoDB: .\ibdata1 can't be opened in read-write mode，innodbibdata1

MYSQL服務無法啟動：InnoDB: .\ibdata1 can't be opened in read-write mode，innodbibdata1

今天在那做實驗倒騰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

--------------------------------------

Dylan    Presents.