[Solved] MYSQL:1153 Got a packet bigger than ‘max_allowed_packet’ bytes

1153: got a packet bigger than ‘Max_ allowed_ Packet ‘bytes

There are two solutions to this problem:

1. Temporary modification:

mysql>set global max_allowed_packet=524288000; #修改 512M

2. To modify my.cnf (my.ini under Windows), restart mysql
add a sentence in the [mysqld] section (if it exists, adjust its value):
Max_ allowed_ Packet = 256M (adjust the value according to the actual situation)

You can use the command:

show VARIABLES like '%max_allowed_packet%’;

Check whether the modification is successful!

Similar Posts: