mysql [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode

最近開始研究mysql，有一臺伺服器，第一次部署時有一些配置檔案的路徑有問題，打算重新部署，因為mysql用的二進位制安裝方式，刪除了mysql目錄，重新部署是報錯：

# ./scripts/mysql_install_db --defaults-file=/etc/my.cnf  --user=mysql
Installing MySQL system tables...2015-05-29 11:18:38 16020 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-29 11:18:38 16020 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-05-29 11:18:38 16020 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-29 11:18:38 16020 [Note] InnoDB: Using Linux native AIO
2015-05-29 11:18:38 16020 [Note] InnoDB: Using CPU crc32 instructions
2015-05-29 11:18:38 16020 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-29 11:18:38 16020 [Note] InnoDB: Completed initialization of buffer pool
2015-05-29 11:18:38 16020 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
2015-05-29 11:18:38 16020 [ERROR] InnoDB: The system tablespace must be writable!
2015-05-29 11:18:38 16020 [ERROR] Plugin 'InnoDB' init function returned error.
2015-05-29 11:18:38 16020 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-05-29 11:18:38 16020 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-05-29 11:18:38 16020 [ERROR] Aborting


2015-05-29 11:18:38 16020 [Note] Binlog end
2015-05-29 11:18:38 16020 [Note] ./bin/mysqld: Shutdown complete


看著很像許可權的問題，但是檢查後發現，許可權很正常，google一下
原來是datadir下的問題，刪除data目錄下的ib_logfile0和ib_logfile1檔案，就可以了，因為是重新部署，所以我把datadir清空了，再次執行安裝指令碼，成功，make一下。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/14184018/viewspace-1676475/，如需轉載，請註明出處，否則將追究法律責任。