Skip to content

MacOS mysql ERROR! The server quit without updating PID file

问题描述

MacOS brew install 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

Disclaimer
  1. License under CC BY-NC 4.0
  2. Copyright issue feedback me#imzye.me, replace # with @
  3. Not all the commands and scripts are tested in production environment, use at your own risk
  4. No privacy information is collected here
Try iOS App