I recently upgraded to MySQL 8.0.11 with brew.
mysql.server start generates this error:
Starting MySQL ..... ERROR! The server quit without updating PID file (/usr/local/var/mysql/Seneca.local.pid).
The PID file does not exist, however. Running just
mysqld shows some errors that look like they’re related to the upgrade.
2018-07-07T17:43:10.619949Z 0 [System] [MY-010116] [Server] /usr/local/Cellar/mysql/8.0.11/bin/mysqld (mysqld 8.0.11) starting as process 83721 2018-07-07T17:43:10.669608Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive 2018-07-07T17:43:12.721431Z 1 [ERROR] [MY-012526] [InnoDB] InnoDB: Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.22. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html 2018-07-07T17:43:12.721510Z 1 [ERROR] [MY-012930] [InnoDB] InnoDB: Plugin initialization aborted with error Generic error. 2018-07-07T17:43:13.030112Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. 2018-07-07T17:43:13.030888Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2018-07-07T17:43:13.030924Z 0 [ERROR] [MY-010119] [Server] Aborting 2018-07-07T17:43:13.034121Z 0 [System] [MY-010910] [Server] /usr/local/Cellar/mysql/8.0.11/bin/mysqld: Shutdown complete (mysqld 8.0.11) Homebrew.
Removing and reinstalling mysql doesn’t help.