windows MySQL报"2006 - MySQL server has gone away"错误,解决过程.
来源:互联网 发布:双流区2016年公交优化 编辑:程序博客网 时间:2024/04/30 07:26
windows MySQL报"2006 - MySQL server has gone away"错误,解决过程.
2015年2月7日10:54:11
1、使用Navicat,执行查询语句"show global variables like '%timeout'",查到wait_timeout=288000.
2、查到文件my.ini,在文件最后([mysqld]段最后),修改“max_allowed_packet = 50M”,添加“interactive_timeout = 2880000”,添加“wait_timeout = 2880000”,保存。
C:\Program Files\MySQL\MySQL Server 5.5\my.ini
3、重启服务。在cmd窗口下,先执行net stop mysql;再执行net start mysql。
4、使用Navicat,执行查询语句"show global variables like '%timeout'",查到wait_timeout=2147483.
1 0
- windows MySQL报"2006 - MySQL server has gone away"错误,解决过程.
- mysql连接报错 '2006, MySQL server has gone away'
- MySQL错误 ERROR 2006 (HY000): MySQL server has gone away
- MySQL server has gone away 错误
- mysql server has gone away 错误
- mysql操作错误server has gone away
- 解决MySQL server has gone away
- 解决MySQL server has gone away
- 解决MySQL server has gone away
- 解决MySQL server has gone away
- 解决 MySQL server has gone away
- mysql恢复报ERROR 2006 (HY000) at line 5303856: MySQL server has gone away错误处理
- MySQL 数据批量恢复时 [Err] 2006 - MySQL server has gone away 错误的解决
- MySQL 数据批量恢复时 [Err] 2006 - MySQL server has gone away 错误的解决
- mac os #2006 - MySQL server has gone away 错误解决办法
- 解决【2006 - MySQL server has gone away】问题
- python< 解决OperationalError (2006, 'MySQL server has gone away')>
- 在处理历史数据时,报mysql server has gone away 2006 的错误
- Android 记事本NotePad
- (二十二)常用方法(工具方法)的抽取
- 【OpenCV归纳】2 读写视频
- Eclipse自动提示功能失效(ctrl + /)解决办法
- 【c++笔记十三】c++中的输入、输出和文件操作
- windows MySQL报"2006 - MySQL server has gone away"错误,解决过程.
- 利用FlashPaper在web页面中显示PDF文件(兼容各浏览器)
- Unable to execute dex: Multiple dex files define 解决方法
- Tsinsen 清橙 A1016. 缩小的陆地 (pi)
- 堆和栈的区别(经典)
- linux ar,gcc,ldd,nm命令详解
- DSAPI多功能组件编程应用-QQ相关
- 精品文章推荐
- 【Jason's_ACM_解题报告】Jurassic Remains