在MySQL 安装目录下的my.ini里面的
[mysql]和[mysqld]的部分分别加上
max_allowed_packet = 20M
然后要重启MySQL service 就可以了。
在MySQL命令行里输入 show variables like 'max_allowed_packet' 就可以查看是否成功修改
详细解决方案
My SQL 批改 max_allowed_packet
热度：353 发布时间：2016-05-05 13:29:28.0
在MySQL 安装目录下的my.ini里面的
[mysql]和[mysqld]的部分分别加上
max_allowed_packet = 20M
然后要重启MySQL service 就可以了。
在MySQL命令行里输入 show variables like 'max_allowed_packet' 就可以查看是否成功修改
相关解决方案
- Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your,该如何处理
- HTTP 异常 405.0 - Method Not Allowed
- 使用MagicAJax的AjaxPanel时有时会弹出"Using the AjaxCallHelper write methods outside of an AjaxCall is not allowed."请教如何解决
- why facebook is not allowed in china?该怎么解决
- why facebook is not allowed in china?解决思路
- Sybase报Invalid packet type 0x22异常
- Operation not allowed for reason code "3" on table xxx,该如何处理
- Operation not allowed for reason code "3" on table xxx,该怎么处理
- db2 在进行表操作时显示如下信息SQL0290N Table space access is not allowed. SQLSTATE=55039,该如何处理
- 解决Symbolic link not allowed or link target not accessible有关问题一例
- Cisco Packet Tracer可以平添新设备吗
- 请教swfupload下传出现File exceeds the maximum allowed size
- 在当地使用Chrome中调试ajax时提示Origin null is not allowed by Access-Control-Allow-Origin
- Fatal error: Allowed memory size of 8388608 bytes exhausted解决办法
- HTTP异常405-Method Not Allowed
- 处理懒加载有关问题后出现的有关问题：Write operations are not allowed in read-only mode (FlushMode.NEVE
- 00.The processing instruction target matching "[xX][mM][lL]" is not allowed
- 调用servlet简单画个框，提示405 Method Not Allowed，了,该如何处理
- 偶然出现：forward() not allowed after buffer has committed
- myeclipse在连接mysql数据源的时分为何总显示the last packet sent successfully to the server was
- Content is not allowed in prolog再发一遍，帮小弟我看看吧，web.xml是自动生成的呀
- 小弟我的ResultSet 报Operation not allowed after ResultSet closed？
- 总是报错 group function is not allowed here 第６行,该怎么解决
- ORA-02287: sequence number not allowed here
- sqlserver2008R2 增添数据 not allowed within multi-statement transaction
- Android有关问题集锦之三十八：not allowed to send broadcast android.intent.action.MEDIA_MOUNTED
- phpmyadmin运行出错，mysqli_init(): Property access is not allowed yet 求解决啊该怎么处理
- 请教swfupload下传出现File exceeds the maximum allowed size
- Fatal error: Allowed memory size of 8388608 bytes exhausted解决办法
- Cisco Packet Tracer可以增添新设备吗