Skip to content

MacOS mysql ERROR! The server quit without updating PID file

问题现象

MacOS brew 安装mysql@5.7后

brew install mysql@5.7
/usr/local/opt/mysql@5.7/bin/mysql.server start

启动报错

mysql ERROR! The server quit without updating PID file

查看日志/usr/local/var/mysql/*.err,报错的主要是这一行

2020-10-06T12:41:39.921803Z 0 [ERROR] unknown variable 'mysqlx-bind-address=127.0.0.1'

解决方法

如果您能够找到您的my.cnf文件(对我来说,它在/usr/local/etc/my.cnf中),您应该删除或注释以下行:

mysqlx-bind-address = 127.0.0.1