mysql-error-2006 – Tarik Billa

#2006 MySQL Server has gone away error in Wamp

August 6, 2023 by Tarik

I’m using XAMPP on Windows and had the same problem. I thought it was the timeout variable but it was max_allowed_packet. This has fixed it: # note the change was made at this section [mysqld] port= 3306 socket= “/xampp/mysql/mysql.sock” basedir=”/xampp/mysql” tmpdir=”/xampp/tmp” datadir=”/xampp/mysql/data” skip-locking key_buffer = 16M # it was 1M by default max_allowed_packet = 2M … Read more

MySQL error 2006: mysql server has gone away

September 30, 2022 by Tarik

I have encountered this a number of times and I’ve normally found the answer to be a very low default setting of max_allowed_packet. Raising it in /etc/my.cnf (under [mysqld]) to 8 or 16M usually fixes it. (The default in MySql 5.7 is 4194304, which is 4MB.) [mysqld] max_allowed_packet=16M Note: Just create the line if it … Read more