Packet for query is too large (5,145 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable.

错误

在使用Mybatis generator时提示MySQL写入过大

Packet for query is too large (5,145 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable.

Packet for query is too large (5,145 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable.

环境

MySQL 8.0.11

Mybatis generator 1.3.7

查询

SHOW VARIABLES LIKE '%max_allowed_packet%'

Packet for query is too large (5,145 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable.

修改my.cnf

在my.cnf中添加

max_allowed_packet=10M

Packet for query is too large (5,145 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable.

重启mysql

Packet for query is too large (5,145 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable.

Packet for query is too large (5,145 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable.

这样就可以了。

上一篇:C语言实现随机生成0或1


下一篇:iOS开发中涉及的字体问题