mysql Packet for query is too large (1185 > 1024)异常

2023-04-25,,

注:最近mysql一直提示如下错误

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

按网上要求,检查max_allowed_packet

show VARIABLES like '%max_allowed_packet%';

修改max_allowed_packet

set global max_allowed_packet = 2*1024*1024*10

或者修改配置文件my.ini(windows)/my.cnf(linux)

max_allowed_packet = 20M

重启

后临时解决问题,但过了与一会儿后问题有存在了。后在http://bbs.csdn.net/topics/390983183上面看到,可能是被攻击

mysql Packet for query is too large (1185 > 1024)异常的相关教程结束。

《mysql Packet for query is too large (1185 > 1024)异常.doc》

下载本文的Word格式文档,以方便收藏与打印。