Mysql Failed to Start on Mac Due to Innnodb Libdata1 Can Not Be Opened in Read Write Mode
Mysql服务进程不能启动: [ERROR] InnoDB: ./ib_logfile0 can’t be opened in read-write mode
背景
昨天重启了macbook之后,今天跑开发, 发现本地mysql连不上, 报错如下
2020-05-10T09:18:05.492947Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-10T09:18:05.510448Z 0 [ERROR] InnoDB: ./ib_logfile0 can't be opened in read-write mode.
2020-05-10T09:18:05.510492Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-05-10T09:18:05.822586Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-05-10T09:18:05.822614Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-05-10T09:18:05.822621Z 0 [ERROR] Failed to initialize builtin plugins.
2020-05-10T09:18:05.822627Z 0 [ERROR] Aborting
解决方案
- 进入
/usr/local/var/mysql/目录, 删除ib_logfile0文件,
rm -rf /usr/local/var/mysql/ib_logfile0
- 重启mysqld搞定