Mysql 报错Packets larger than max_allowed_packet are not allowed
来源:互联网 发布:99客服软件 编辑:程序博客网 时间:2024/06/02 12:46
今天使用mysql数据库存储数据发现报错:Packets larger than max_allowed_packet are not allowed.
windows操作如下 打开mysql CMD窗口 输入命名: show VARIABLES like '%max_allowed_packet%'; 查看接收数据包大小
我的是4M 如果过小请通过命令修改 set global max_allowed_packet = 2*1024*1024*10
修改后重启数据库服务:在用 show VARIABLES like '%max_allowed_packet%'; 查看完成修改
重启服务在:我的电脑 -> 右击选着 -> 管理-> 服务和应用程序->服务-> 找到Mysql57(这是我的)->右击->重新启动。 完成
2017-8-18 修改 新添加点东西
如果 用上面的命令修改后 过一段时间又出现这个问题那么 有可能你用的是 Root 账户 和简单的密码 被人攻击后 会修改为1024 建议修改密码为强密码 包含大小写 特殊字符可以避免被攻击 或者限制 访问IP 或者 用其它用户登录 mysql
同时附上 两句代码
1. update user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where user = 'root';
1是修改密码的Mysql代码 修改密码为文中的 ‘root’ 该代码在 mysql数据库执行否则无效
2. flush privileges;
2是 重启mysql服务命令
2017-10-17修改 新添加点东西
就是数据库timeout超时 8小时连接断开问题 window系统在MySQL 安装目录找到 MySQL\MySQL Server 5.7
在文档最下面添加
wait_timeout = 天*时*分*秒
interactive_timeout = 天*时*分*秒
然后重启数据库 命令为 flush privileges;
- MYSQL报错“Packets larger than max_allowed_packet are not allowed”
- Mysql 报错Packets larger than max_allowed_packet are not allowed
- Packets larger than max_allowed_packet are not allowed
- mysql Packets larger than max_allowed_packet are not allowed
- 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产生一个随机数时,报Recursive stored functions and triggers are not allowed.
- Write operations are not allowed in read-only tomcat报错
- Spring+Hibernate报错:Write operations are not allowed in read-only mode (FlushMode.NEVER/MANUAL)
- 保存数据报错Write operations are not allowed in read-only mode (FlushMode.MANUAL)
- vuejs 报错 Decimals with leading zeros are not allowed in strict mode
- Angular报错[ngRepeat:dupes] Duplicates in a repeater are not allowed.
- - s4s-elt-character: Non-whitespace characters are not allowed in schema elements other than 'xs:app
- windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
- windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
- python画直方图报错——max must be larger than min in range parameter
- sql错误1301 Result of CONCAT() was larger than max_allowed_packet(1024)-truncated
- Leetcode之Candy分糖果问题
- k-近邻算法小结
- Java NIO:NIO概述
- Matlab局部放大_20170815
- Struts2动态方法报错
- Mysql 报错Packets larger than max_allowed_packet are not allowed
- KMP相关算法
- HBase判断表是否存在
- map函数
- linux进程之fork函数
- SPFA
- javascript:除去数组的重复项
- Python实现:利用GBDT产生新特征(GBDT+Linear Regression)
- Java并发编程:Thread类的使用