Category: MySQL
When you change Max_Allowed_Packet_Size using the command line or an admin tool, sometimes it does not work.
The best way to do this is to edit the my.cnf file. Under the mysqld section, add the following line:
[mysqld max_allowed_packet=16MB
Normally it is good to set the value to around 16mb. It is only set to 1mb by default.
Restart mySQL after you have edited the file:
On Linux:
/etc/rc.d/init.d/mysqld restart
On Windows:
Use services to restart
Tags:
mySQL