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.
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
Post a Comment