在撤销 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