I'm getting a weird message from phpmyadmin saying:

#2006 - MySQL server has gone away

What I found online is that I should increase the size of max_allowed_packet witch should be in the my.conf file witch is located at /etc/my.cnf. Untill now everything is fine, but the problem is that this file does not contain what I need.

Here is the content of the .cnf file on my server:

# Disabling symbolic-links is recommended to prevent assorted security risks


Where should I look in order to increase the size of the packet? I'm new in the linux world and I'm lost.

migrated from stackoverflow.com Jul 16 '13 at 8:51

This question came from our site for professional and enthusiast programmers.


You need to change the my.cnf file to include the single line under [mysqld] in your file


now restart the MySQL service and you are done.

You can see its current value in mysql like this:

SHOW VARIABLES LIKE 'max_allowed_packet'

You can try changing it like this, but it's unlikely this will work on shared hosting:

SET GLOBAL max_allowed_packet=16777216;

Also please read this: http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html


You can set the limit to (for example) 8M

mysql> set global max_allowed_packet=8M
  • I already tried it, Then I restarted MySQL, nothing happened. I restarted the whole server, but the issue remains :( – Slim Jul 16 '13 at 8:22
  • That's because setting server variables with SET GLOBAL doesn't persist on MySQL restart. You can use it to set a variable without restarting MySQL, but to make it persist you have to put in my.cnf as well. – redguy Jul 17 '13 at 10:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy