mac下启动mysql, 报错Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

最新推荐文章于 2025-09-06 10:53:33 发布

原创最新推荐文章于 2025-09-06 10:53:33 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

2 篇文章

订阅专栏

本文解决了一个常见的问题：在Mac升级后，由于mysqld未启动导致的MySQL无法连接。通过在终端中运行mysqld命令，可以成功启动MySQL服务，并恢复正常连接。

前几天还可以登陆mysql, 今天竟然就登陆不上了, 报错Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).

网上查找了一些资料, 发现是mac升级后, 导致mysqld没有启动, 从而出现这样的错误.

修复方法如下:

终端输入: mysqld

2019-11-24T02:22:50.244065Z 0 [System] [MY-010116] [Server] /usr/local/Cellar/mysql/8.0.17_1/bin/mysqld (mysqld 8.0.17) starting as process 81400
2019-11-24T02:22:50.246827Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2019-11-24T02:22:50.808617Z 0 [System] [MY-010229] [Server] Starting crash recovery...
2019-11-24T02:22:50.817542Z 0 [System] [MY-010232] [Server] Crash recovery finished.
2019-11-24T02:22:50.899899Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-11-24T02:22:50.944323Z 0 [System] [MY-010931] [Server] /usr/local/Cellar/mysql/8.0.17_1/bin/mysqld: ready for connections. Version: '8.0.17'  socket: '/tmp/mysql.sock'  port: 3306  Homebrew.
2019-11-24T02:22:51.045745Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060

mysqld启动, 生成/tmp/mysql.sock.

此时, 重新登陆mysql, 可正常连接.