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.

环境#

MySQL 8.0.11

Mybatis generator 1.3.7

查询#

SHOW VARIABLES LIKE '%max_allowed_packet%'

修改my.cnf#

在my.cnf中添加

max_allowed_packet=10M

重启mysql

这样就可以了。