在遇到ERROR 2013 (HY000): Lost connection to MySQL server错误时，检查了socket配置、重启MySQL服务并查看error.log日志，发现因内存不足导致InnoDB初始化失败。通过设置innodb_force_recovery=6临时解决，并备份所有数据库。最终，创建新的MySQL实例并导入数据。
在撤销 LOAD DATA LOCAL INFILE 后，执行其他 sql 语句出现以下错误：
mysql> show databases;
No connection. Trying to reconnect...
Connection id: 5
Current database: *** NONE ***
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
ERROR:
Can't connect to the server
根据错误查看了，socket 和 my.cnf 配置文件
more /etc/mysql/my.cnf | grep sock
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
socket = /var/run/mysqld/mysqld.sock
socket = /var/run/mysqld/mysqld.sock
socket = /var/run/mysqld/mysqld.sock
socket 运行正常，尝试重启 m
最低0.47元/天 解锁文章
4021
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
