MySQL server has gone away

问题描述

mysql报错 2006, MySQL server has gone away

解决方法

1. 修改 /etc/mysql/mysql.conf.d/mysqld.cnf 配置 ^2

   • 设置wait_timeout

     例如: 设置wait_timeout=180

   • 设置max_allowed_packet

     [mysqld]
     max_allowed_packet=16M

   • 使用 mysqli_ping ^1

1. 重启 mysql

   $ sudo /etc/init.d/mysql restart

---

参考文档

• MySQL: “Warning: MySQL server has gone away”
• How do I fix the error “Mysql Server has gone away”?
• MySQL error 2006: mysql server has gone away
• B.5.2.9 MySQL server has gone away
• Why /etc/mysql/my.cnf is EMPTY?
• mysqli::ping
• Ubuntu MySQL