windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
来源:互联网 发布:阿里云部署java项目 编辑:程序博客网 时间:2024/06/09 19:24
windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
2014年11月24日10:20:03
1、使用navicat,执行查询“show VARIABLES like '%max_allowed_packet%';”,查到值为1048576。
2、查到文件my.ini,在文件最后([mysqld]段最后),添加“max_allowed_packet = 20M”,保存。
3、重启服务。在cmd窗口下,先执行net stop mysql;再执行net start mysql。
4、使用navicat,执行查询“show VARIABLES like '%max_allowed_packet%';”,查到值为20971520。
0 0
- windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
- windows 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
- 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 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: 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的问题
- 项目jar包 与tomcat 自带jar 冲突
- EditText在XML布局中设置inputType后hint字体会改变
- 第13周项目2-成绩处理
- 第十三周项目四2—字符数组排序
- vmware ubuntu linux tomcat Xshell Xftp 搭建网站后台——(一)环境搭建-vmware安装
- windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
- SQL查询统计表中一列求和
- CodeForces 490C Hacking Cypher
- 在Oracle中执行动态SQL的几种方法
- Android中全屏 取消标题栏,TabHost中设置NoTitleBar的三种方法
- 小车遥控器干扰器--车罩起火殃及爱车 保险公司表示不赔
- Ajax提交回写 form提交
- shfileoperation 提示无法删除文件的有关问题
- 串口编程及实例