Mysql实战详解9：Packet for query is too large (1025 ＞ 1024) 问题解决

连接MySql时候出现错误：

### Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1025 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
; Packet for query is too large (1025 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1025 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:110)

原因是默认的包太小了，修改一下配置即可！

解决方法：

1.查看 max_allowed_packet大小

show VARIABLES like '%max_allowed_packet%';

可以看到默认max_allowed_packet是1024

 

2. 修改max_allowed_packet，

编辑 vi