Packets larger than max_allowed_packet are not allowed

“A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a master replication server to a slave.”

You can view this setting:

1
2
3
SHOW VARIABLES LIKE 'max_allowed_packet';

Default before change would show: 4194304

To change this in windows you must find and update the config file for the service:

1
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57

Edit the file and change the ‘max_allowed_packet’ value from 4M to something larger like 10M (this is 10 mb)

If you are running linux you can try this to set it to 16M

1
SET GLOBAL max_allowed_packet=16777216;

References