user warning: Got a packet bigger than 'max_allowed_packet' bytes

Submitted by Eric.London on 8/1/2008

Tags:

Add new comment

I just the following error when loading a large cck node form:

user warning: Got a packet bigger than 'max_allowed_packet' bytes

You can resolve this error by adding a line to your /etc/my.cnf MySQL configuration:
[mysqld]
set-variable = max_allowed_packet=32M

MAMP

Submitted by Eric.London on Thu, 02/17/2011 - 10:55.

And if you are using MAMP, you can copy this file..

/Applications/MAMP/Library/share/mysql/my-small.cnf

to this folder..

/Applications/MAMP/db/mysql/

rename it to "my.cnf", make your changes, and restart your MySQL service.

setting variables without restarting MySQL

Submitted by Eric.London on Wed, 12/08/2010 - 13:08.

You can also change this variable without restarting MySQL.

root@server [/etc]# mysql --execute="show variables" | grep -ir max_allowed_packet
max_allowed_packet	16777216

root@server [/etc]# mysql --execute="set global max_allowed_packet=33554432"

root@server [/etc]# mysql --execute="show variables" | grep -ir max_allowed_packet
max_allowed_packet	33554432

(thanks Mike!)