windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
来源:互联网 发布:淘宝账号登录首页 编辑:程序博客网 时间:2024/06/04 19:01
windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
2017年07月07日
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的问题
- ionic使用(三):下拉刷新显示新闻
- 141 Linked List Cycle
- Please change caller according to com.intellij.openapi.project.IndexNotReadyException documentation
- 变量
- 【备忘】零基础学习spark之王家林最新高清视频教程
- windows MySQL 报“Got a packet bigger than 'max_allowed_packet' bytes”错误,解决过程.
- php 实现单点登入
- ubuntu上pushd命令执行错误(/bin/sh: 1: pushd: not found)解决办法
- Unresolved attribute reference 'objects' for class
- Nginx与Nginx-rtmp-module搭建RTMP视频直播和点播服务器
- 几种使用itext生成pdf的方式
- yuv420P数据对AVFrame的赋值
- 网站备案需要注意
- UML---实现图(部署图和构件图)