MySQL won't start following upgrade on High Sierra


(John D.) #1

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.


(Sean Molenaar) #2

did you run the mysql_upgrade command that mysql ships with for upgrading? https://dev.mysql.com/doc/refman/5.5/en/mysql-upgrade.html


(John D.) #3

There is more about this issue here:

I reverted successfully to 5.7.


(Carlos A.) #4

Dear friends:

I followed this:

All ok here.

And this:

In point 7, with sudo tail /usr/local/var/mysql/localhost.err I get this:

2018-08-10T03:20:32.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql

2018-08-10T03:20:32.602271Z 0 [System] [MY-010116] [Server] /usr/local/Cellar/mysql/8.0.12/bin/mysqld (mysqld 8.0.12) starting as process 3937

2018-08-10T03:20:32.623035Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive

[warn] kq_init: detected broken kqueue; not using.: Invalid argument

2018-08-10T03:20:33.466355Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2018-08-10T03:20:33.518044Z 0 [System] [MY-010931] [Server] /usr/local/Cellar/mysql/8.0.12/bin/mysqld: ready for connections. Version: '8.0.12' socket: '/tmp/mysql.sock' port: 3306 Homebrew.

2018-08-10T03:29:54.642539Z 0 [System] [MY-010910] [Server] /usr/local/Cellar/mysql/8.0.12/bin/mysqld: Shutdown complete (mysqld 8.0.12) Homebrew.

2018-08-10T03:29:54.6NZ mysqld_safe mysqld from pid file /usr/local/var/mysql/MBP-R-319.local.pid ended

But with mysql -u root -p I got:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

And I can’t continue with next steps.

Any Idea to solve it?


(Sean Molenaar) #5

Your server is shutting down, it needs to be running to connect to it. But how to configure software that homebrew ships isn’t really the focus of this forum.