How to solve MySQL error: Last_IO_Error Got a packet bigger than 'max_allowed_packet' bytes

To solve this problem, we need to change

max_allowed_packet=4096M ( or some other value suitable for you)

in /etc/my.cnf
file.

To make sure we set it correctly, run

select @@max_allowed_packet;

If you unfortunately put more than 2 lines of "max_allowed_packet= " in the configuration file, the last one takes effect.

Comments