无法连接到mysql的解决方法

有时候用着mysql，会遇到如下这种情况

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    9636
Current database: security

你会发现不管是start还是restart都没什么用

首先输入命令ps aux | grep mysql，得到

_mysql             953   0.0  0.2  2835036  12600 s003  S    六08下午   0:26.87 /usr/local/Cellar/mysql/5.7.20/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.7.20 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.7.20/lib/plugin --user=mysql --log-error=qiqi-Mac.err --pid-file=/usr/local/var/mysql/qiqi-Mac.pid
root               859   0.0  0.0  2444660   1428 s003  S    六08下午   0:00.02 /bin/sh /usr/local/Cellar/mysql/5.7.20/bin/mysqld_safe --datadir=/usr/local/var/mysql --pid-file=/usr/local/var/mysql/qiqi-Mac.pid
qiqi             34856   0.0  0.0  2442020   1984 s003  S+    4:03下午   0:00.00 grep --color=auto mysql

结束进程，输入sudo kill 953 sudo kill 859
cd /usr/local/var/mysql进入mysql所在目录
sudo rm *.err删除所有错误记录sudo rm *.pid删除pid文件
ls一下
sudo mysql.server start启动mysql
之后就能正常使用了

貌似有不少人都会遇到这种问题

CATALOG

FEATURED TAGS

FRIENDS