Mac Mysql [ERROR] Do you already have another mysqld server running on socket:

285 阅读1分钟

Mysql 启动 Do you already have another mysqld server running on socket: /tmp/mysql.sock

进入 /mysql/support-files 执行 mysql.server start
启动报错,提示错误日志在 /data/mideMacBook-Pro.local.err
  • mideMacBook-Pro.local.err 错误内容如下
2022-03-07T02:10:47.619625Z 0 [ERROR] Can't start server : Bind on unix socket: Address already in use
2022-03-07T02:10:47.619631Z 0 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
2022-03-07T02:10:47.619700Z 0 [ERROR] Aborting
  • 解决方案
// Can't start server : Bind on unix socket: Address already in use 当前 3306端口并没有被占用,且没有另一个mysql正在运行
// 猜测,可能是由于电脑在上次关机之前没有正常的执行关闭mysql的命令
进入 /tmp 文件夹,将mysql.sock 删除(ls命令 看不到 mysql.sock 文件的存在,但是实现删除命令后,mysql可以启动)
sequenceDiagram
Alice->>John: Hello John, how are you?
John-->>Alice: Great!
Alice-)John: See you later!