MediumBlob类型存储的数据超过1M或4M以上,出现异常:
Packet for query is too large (6,389,101 > 4,194,304). You can change this value on the server bysetting the 'max allowed packet' variable
解决步骤如下:
1、在注册表中,找到mysql对应的my.ini文件的地址,修改mysql配置文件my.ini文件
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL83
2、配置max allowed packet选项
3、重启mysql服务器