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:


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




How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.