Packet for query is too large (12164278 > 4194304). You can change this value(亲测有效)

时间:2024-04-10 22:22:13

一、报错如下:

Packet for query is too large (12164278 > 4194304). You can change this value

二、解决方式如下:

1、查看mysql的配置文件my.ini,发现max_allowed_packet值为4M太小了(这里4194304=410241024),修改如下:

Packet for query is too large (12164278 > 4194304). You can change this value(亲测有效)
2、重启mysql服务即可。