MYSQL报错 error: Got a packet bigger than ‘max_allowed_packet’ bytes
来源:互联网 发布:ubuntu重启搜狗输入法 编辑:程序博客网 时间:2024/05/21 03:25
MySQL数据库:2016年4月7日
导入数据库SQL文件时报错: Got a packet bigger than ‘max_allowed_packet’ bytes
经过大量搜索研究发现是my.ini配置文件的问题
重要的事儿说三遍:max_allowed_packet、max_allowed_packet、max_allowed_packet。
如果是Linux 下的话配置:进入服务器路径 /etc 找到 my.cnf 在里面的 mysqld 段中找到 max_allowed_packet = 大小修改到适当大小并保存,然后重新启动 mysql 服务器,即可。如果没有这行就增加这行。如果是Windows下的话配置:[mysqld]部分下边添加:max_allowed_packet=500M即可,重启就OK。
0 0
- MYSQL报错 error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MySQL数据库报错(会自动关闭):Got a packet bigger than 'max_allowed_packet' bytes
- 针对 mysql 中数据导入报错:Got a packet bigger than‘max_allowed_packet’bytes的问题
- MySql查询大量数据时报错Error Code:1153 Got a packet bigger than 'max_allowed_packet' bytes
- error: Got a packet bigger than ‘max_allowed_packet’ bytes
- Got a packet bigger than 'max_allowed_packet' bytes
- Got a packet bigger than 'max_allowed_packet' bytes
- Got a packet bigger than 'max_allowed_packet' bytes
- mysql-Got a packet bigger than ‘max_allowed_packet’ bytes
- MySQL Got a packet bigger than 'max_allowed_packet' bytes错误
- MySQL Got a packet bigger than 'max_allowed_packet' bytes错误
- MySQl Got a packet bigger than ' max_allowed_packet' bytes
- Mysql提示 “ Got a packet bigger than 'max_allowed_packet' bytes”
- MySQL Got a packet bigger than 'max_allowed_packet' bytes错误
- windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
- windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
- maven环境介绍及环境搭建
- FZU 2026代码问题
- PHP开发APP接口
- 将Drawable转为Bitmap
- 5.6.2 sigsetjmp/siglongjmp错误处理架构
- MYSQL报错 error: Got a packet bigger than ‘max_allowed_packet’ bytes
- web项目部署时的标准目录结构
- SDWebImage的缓存怎么不要
- Intellij IDEA 的 Test Restful Web Service 使用教程
- python开发笔记
- JS禁止网页被复制以及禁止鼠标右击代码
- Unity3d 读写文本
- springmvc hadoop nginx ffmpeg 在线转码实现点播服务demo
- neo4j入门