5.7が入っていた環境に8.0をインストールした場合に発生するらしい
2019-09-15T08:27:16.967577Z 0 [System] [MY-010116] [Server] /usr/local/opt/mysql/bin/mysqld (mysqld 8.0.17) starting as process 33650
2019-09-15T08:27:16.973105Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2019-09-15T08:27:17.111260Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.10. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2019-09-15T08:27:16.984522Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
一旦、すべて削除する。 必要ならバックアップを取ること。 $ brew uninstall mysql brew uninstall mysql では削除できないファイル群を削除します。 $ sudo rm -rf /usr/local/Cellar/mysql* $ sudo rm -rf /usr/local/bin/mysql* $ sudo rm -rf /usr/local/var/mysql* $ sudo rm -rf /usr/local/etc/my.cnf $ sudo rm -rf /usr/local/share/mysql* $ sudo rm -rf /usr/local/opt/mysql $ sudo rm -rf /usr/local/mysql $ sudo rm -rf /Library/StartupItems/MYSQL $ sudo rm -rf /Library/PreferencePanes/MySQL.prefPane $ sudo rm -rf /Library/Receipts/mysql-.pkg $ sudo rm -rf /usr/local/Library/LinkedKegs/mysql
必要なバージョンをインストールし直す。
$ brew install mysql@5.7
パスを通す
$ echo ‘export PATH=”/usr/local/opt/mysql@5.7/bin:$PATH”‘ >> ~/.bash_profile
$ source ~/.bash_profile
$ mysql.server start