Got a packet bigger than ' Max_allowed_packet '

I found this error in some places when I was importing data yesterday. Later discovered that I use the RPM package MySQL configuration file inside has the Old_passwords=1 to remove is OK.

Got a packet bigger than ‘max_allowed_packet’ bytes or ERROR 1153 (08S01) at line 616: Got a packet bigger than ‘max_allowed_packet’ by tes...

I found this error in some places when I was importing data yesterday.

Later discovered that I use the RPM package MySQL configuration file inside has the Old_passwords=1 to remove is OK.

And then there max_allowed_packet=500M 's nothing wrong with that.

PS: It is recommended to turn off the old_passwords option in the 5.0 version.

If you don't know if your old_passwords is turned on, you can use the command.

show VARIABLES like '%old_passwords%';

query result(1 records)

Variable_name Value
old_passwords OFF