MySQL Packet for query is too large


500, Server error. 糟糕,服务器异常,您可以点击这里 返回首页或刷新页面重试! Error:服务运行异常, ### Error querying database. Cause: com.mysql.jdbc.PacketTooBigException:
Packet
for query is too large (8208 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
### The error may exist in file [D:szkj ewproject uichi argetclassescomvacomallmapperxmlSysMenuMapper.xml]
### The error may involve defaultParameterMap ### The error occurred while setting parameters ###
SQL: SELECT id,menuName,pid,url,icon,sort,deep,code,`resource` FROM sys_menu WHERE (pid = ? AND id IN

参考博客:http://blog.csdn.net/linhaiguo/article/details/50763104

show VARIABLES like '%max_allowed_packet%';

set global max_allowed_packet = 1*1024*10

原文地址:https://www.cnblogs.com/jwlfpzj/p/7503858.html