解决MySQL错误reading initial communication packet_MySQL的两种方法
来源:互联网 发布:传奇游戏源码是什么 编辑:程序博客网 时间:2024/05/22 06:24
解决MySQL错误reading initial communication packet_MySQL的两种方法
打开MYSQL的时候提示reading initial communication packet,
而且网站访问出现如题reading initial communication packet(2013)错误,
处理方法一:
查找MYSQL配置文件:
检查my.cnf,发现innodb_buffer_pool_size = 18M 设置过小,调整为innodb_buffer_pool_size = 1024M即可,网上介绍是过大处理其他解决方法,解决我的问题。
Lost connection to MySQL server at 'reading initial communication packet' 错误解决
如果还不能处理问题则采用下面方法;
1、修改mysql配置文件
vi /etc/my.cnf
[mysqld]段加skip-name-resolve
在这个之前要把mysql的远程访问权限打开,或者再加skip-grant-table(不推荐)
2、修改hosts.allow
vi /etc/hosts.allow
加mysqld : ALL : ALLOW
mysqld-max : ALL :ALLOW
这一次搞定!
- 解决MySQL错误reading initial communication packet_MySQL的两种方法
- 解决MySQL错误reading initial communication packet_MySQL的两种方法
- Lost connection to MySQL server at 'reading initial communication packet' 错误解决
- mysql reading initial communication packet
- reading initial communication packet
- MySQL连接出现错误 'reading initial communication packet', system error: 0
- MySQL _Windows 环境下 MySQL:reading initial communication packet 问题解决
- 遇见Lost connection to MySQL server at 'reading initial communication packet',system error:0的解决办法
- Lost connection to MySQL server at ‘reading initial communication packet
- Lost connection to MySQL server at ‘reading initial communication packet
- 有关Mysql出现Lost connection to MySQL server at 'reading initial communication packet', system error: 0的一个解决方案
- mysql报错:Lost connection to MySQL server at 'reading initial communication packet'
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0 mysql远程连接
- 连接mysql出现Lost connection to MySQL server at 'reading initial communication packet', system error: 0
- MySQL error: 2013, “Lost connection to MySQL server at 'reading initial communication packet', syste
- MySql Lost connection to MySQL server at 'reading initial communication packet', system error: 0
- Lost connection to MySQL server at ‘reading initial communication packet’, system error: 111
- lost connection to mysql server at 'reading initial communication packet',system error:2
- 关于SHFileOperation引发的问题
- HDU/HDOJ 1312 Red and Black 非常简单的搜索题 BFS
- HDU 4565 -- So Easy! 数学 && 2013 ACM-ICPC 长沙赛区全国邀请赛 A题
- java中的File.separator
- 字符串大小比较
- 解决MySQL错误reading initial communication packet_MySQL的两种方法
- 关于职场方面的文章书籍,请看这里
- 用串的顺序存储结构实现串替换操作Replace(&S,T,V)
- DWR群聊实现-第二节
- 判断字符串是否回文
- linux下挂载U盘、硬盘等
- 标准C---关于字符串操作
- 编译原理实验改进版(词法分析)
- Win7非密钥激活