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