com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4232009 > 4194304). Dear 丶 2022-09-22 01:12 92阅读 0赞 > com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4232009 > 4194304). You can change this value on the server by setting the max\_allowed\_packet’ variable. 先查看一下默认配置 ![这里写图片描述][20160624184958582] 进入mysql的安装目录(以windows为例) ![这里写图片描述][20160624184511247] 然后输入以下命令 mysqld --max_allowed_packet=8M ![这里写图片描述][20160624184938831] # 参考文献 # > [MySQL官方文档][MySQL] [20160624184958582]: /images/20220721/a76d4785cbd442009d1b86082c1283de.png [20160624184511247]: /images/20220721/4334c09c3cef44a9883bee4d79afa52b.png [20160624184938831]: /images/20220721/dd171ba0d21047e28c53117055dea6f2.png [MySQL]: http://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
还没有评论,来说两句吧...