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: dig +short txt issue.imzye.com
  3. Not all the commands and scripts are tested in production environment, use at your own risk
  4. No privacy information is collected here
Buy Me a Coffee