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

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

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

前几天还可以登陆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, 可正常连接.

评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值