安裝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檔案。
再次啟動,正常