Mysql服务进程不能启动: [ERROR] InnoDB: ./ib_logfile0 can’t 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

解决方案

1. 进入/usr/local/var/mysql/ 目录, 删除ib_logfile0文件,