错误信息:
MySQL system variable 'max_allowed_packet'
is set to 4194304 Byte (4MB).
解决方案:
1 --> 修改配置文件
到目录 C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.6 下, 找到my.ini 文件。
修改里面的参数:
# 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=32M
2 --> 口令修改:
set global max_allowed_packet = 2*1024*1024*132
然后关闭掉connection,再进入。
show VARIABLES like '%max_allowed_packet%';