MYSQL服務(wù)無(wú)法啟動(dòng):InnoDB: .\ibdata1 can't be opened in read-write mode
2017-12-26 23:08:45
17290
實(shí)驗(yàn)倒騰mysql數(shù)據(jù)庫(kù),后來(lái)發(fā)現(xiàn)服務(wù)無(wú)法啟動(dòng),查看日志報(bào)錯(cuò)如下:
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、打開任務(wù)管理器終止mysqld進(jìn)程;
2、打開mysql安裝目錄的data文件夾,刪除以下2個(gè)文件:
ib_logfile0和ib_logfile1
3、重新啟動(dòng)mysql