mysql 数据库连接 报 Packet for query is too large ( > 1024 )解决办法

 Packet for query is too large (1706 > 1024). You can change this value on the server by setting the

出现这个错误，百分之90是mysql 中max_allowed_packet 设置小了

可以登录数据库通过 show variables like '%max_allowed_packet%'查看。

网上好多人通过语句去修改max_allowed_packet --->set global max_allowed_packet=1024*1024*10*2(单位为B)

但是重启Mysql还是会恢复到默认值