mysql plugin filed_MySQL启动时报Plugin 'InnoDB' registration as a STORAGE ENGINE failed.错误
當更改了MySQL參數后,重新啟動MySQL數據庫,查看日志發現以下錯誤信息
141029? 2:23:37 [ERROR] Plugin ‘InnoDB‘ init function returned error.
141029? 2:23:37 [ERROR] Plugin ‘InnoDB‘ registration as a STORAGE ENGINE failed.
解決辦法
[[email?protected] mysql]# ls
ibdata1??master.info????mysql-bin.000002? mysql-bin.000005???? mysql-relay-bin.000027? mysql.sock
ib_logfile0? mysql???????? mysql-bin.000003? mysql-bin.000006???? mysql-relay-bin.000028? relay-log.info
ib_logfile1? mysql-bin.000001? mysql-bin.000004? mysql-bin.log.index? mysql-relay-bin.index?? test
將ib_logfile刪除
[[email?protected] mysql]# rm -rf ib_logfile*
重新啟動mysql
[[email?protected] mysql]# service mysqld restart
停止 mysqld:??????????????????????????????????????????????? [確定]
正在啟動 mysqld:????????????????????????????????????????? [確定]
問題解決
原文:http://ovcer.blog.51cto.com/1145188/1568968
總結
以上是生活随笔為你收集整理的mysql plugin filed_MySQL启动时报Plugin 'InnoDB' registration as a STORAGE ENGINE failed.错误的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: mysql group by 无效_My
- 下一篇: mysql的分区技术作用_理解MySQL