packet for query is too large <1781> 1024 >. you can change this value on the server by setting the

来源:互联网 发布:谭维维和尚雯婕 知乎 编辑:程序博客网 时间:2024/06/01 10:39
packet for query is too large <1781> 1024 >. you can change this value on the server by setting the max_allowed_packet' variable
解决方法:进入mysql的安装目录找到my.ini 文件  搜索max_allowed_packet 是否存在  如果存在则 改成50M 或者 20M如果不存在 则加上 max_allowed_packet=50M //最初# The maximum size of one packet or any generated or intermediate string, or any parameter sent by the# mysql_stmt_send_long_data() C API function.max_allowed_packet=4M//修改后# The maximum size of one packet or any generated or intermediate string, or any parameter sent by the# mysql_stmt_send_long_data() C API function.max_allowed_packet=50M
0 0
原创粉丝点击