Kevin Dees
← All writing
 ·  1 min read

Fixing MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes

Resolve MySQL error 1153 by increasing the max_allowed_packet setting in the MySQL configuration file.

#Fix#SQL#Web
Fixing MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes

To fix, "MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes" on Ubuntu edit your /etc/mysql/mysql.conf.d/mysqld.cnf.

bash
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Once you have opened the file, increase the max_allowed_packet to a value that works for your environment. For example, in a local development environment, 100M can work.

bash
max_allowed_packet=100M

Then restart MySQL.

bash
sudo service mysql restart

Resources ​