Skip to Content

MySQL server has gone away

Estimated Reading Time: 1 Minutes

This issue usually encounters when max_allowed_packet has very low value than the data you submitted via query. This can be fixed by increasing max_allowed_packet variable value so it is recommended to edit this variable through /mysql/bin/my.ini (Windows) or /etc/my.cnf  (Linux/UNIX) config file. It should look like as follows:

 
my.ini / my.cnf Configuration Sample

[mysqld]

max_allowed_packet = 16M

Explanation: max_allowed_packet is set to 16 Megabytes

Once, you have updated the value then restart your MySQL Server and you’re done!

That’s it!

NOTE: If you are not sure how to do this then kindly reach out to your web server administrator and ask to make this change.

  • Applicable To: Standard Edition, Standard (Multi-Language) Edition, Enterprise Edition (MySQL), Enterprise Multi-Language Edition (MySQL), Enterprise Edition (SQL Server), Enterprise Multi-Language Edition (SQL Server)
MySQL server has gone away
  • COMMENT