ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error:
来源:互联网 发布:软件测试规范标准 编辑:程序博客网 时间:2024/06/05 14:17
From documentation:
More rarely, it can happen when the client is attempting the initial connection to the server. In this case, if your connect_timeout value is set to only a few seconds, you may be able to resolve the problem by increasing it to ten seconds, perhaps more if you have a very long distance or slow connection. You can determine whether you are experiencing this more uncommon cause by using SHOW STATUS LIKE 'aborted_connections'. It will increase by one for each initial connection attempt that the server aborts. You may see “reading authorization packet” as part of the error message; if so, that also suggests that this is the solution that you need.
Try increasing connect_timeout in your my.cnf file
Another style:
MySQL: Lost connection to MySQL server at 'reading initial communication packet'
At some point, it was impossible for remote clients to connect tothe MySQL server.
The client (some application on a Windows platform) gave a vaguedescription like
Connection unexpectedly terminated
.When remotely logging in with the MySQL client the following errorappeared:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
On FreeBSD this happens because there was no match found in /etc/hosts.allow.
Adding the following line before the line sayingALL:ALL
fixes this:
mysqld: ALL: allow
On non-FreeBSD Unix systems, it is worth to check the files /etc/hosts.allow
and/etc/hosts.deny.
If you are restricting connections, make sure this line is in/etc/hosts.allow
:
mysqld: ALL
or check if the host is listed in /etc/hosts.deny.
In Arch Linux, a similar line can be added to /etc/hosts.allow
:
mysqld: ALL
This is usually caused by an aborted connect. You can verify this by checking the status:
mysql> SHOW GLOBAL STATUS LIKE 'Aborted_connects';
If this counter keeps increasing as you get the lost connections, that's a sign you're having a problem during connect.
One remedy that seems to work in many cases is to increase the timeout. A suggested value is 10 seconds:
貌似有效的设置方法
1. mysql> SET GLOBAL connect_timeout = 30;
2.
在文件my.ini 或者my.cnf中添加或更改一个参数:connect_timeout=30
Another common cause of connect timeouts is the reverse-DNS lookup that is necessary when authenticating clients. It is recommended to run MySQL with the config variable in my.cnf:
[mysqld]skip-name-resolve
This means that your GRANT statements need to be based on IP address rather than hostname.
I also found this report from 2012 at the f5.com site (now protected by login, but I got itthrough Google cache)
It is likely the proxy will not work unless you are running BIG-IP 11.1 and MySQL 5.1, which were the versions I tested against. The MySQL protocol has a habit of changing.
I suggest you contact F5 Support and confirm that you are using a supported combination of versions.
Another possibility can be connection reset from the TCP wrappers (/etc/hosts.deny and /etc/hosts.allow). Just check what is coming in from the telnet to port 3306 - if it is nothing, then there is something is in the middle preventing communication from happening.
- ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error:
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error:
- Mysql 错误解决:ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet'
- mysql连接远程数据库出现 ERROR 2013 (HY000) Lost connection to MySQL server at 'reading authorization packet',
- 手把手解决Mysql错误:Lost connection to MySQL server at 'reading authorization packet', system error: 0
- 2013 - 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: 0 mysql远程连接
- 连接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', 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
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0
- Lost connection to MySQL server at 'reading initial communication packet et system error:0
- 遇见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的一个解决方案
- 打开MYSQL时出现闪退lost connection to mysql server at 'reading initial communication packet' system error
- Lost connection to MySQL server at 'reading authorization packet' 处理解决办法
- 解析KVO实现原理
- Fundamental MATLAB Classes
- 第十七项目5--玩日期时间(1,2,3)
- ORA-12518: TNS: 监听程序无法分发客户机连接
- 软件测试入门-举例
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error:
- 蛋蛋的问题(二)--错误--用%d输入英文字母
- Unity中路径获取拼接
- Oracle数据库给表增加一列并给默认值和删除一列
- perl :^I;regexp;push/pop/正则集合
- NSRegularExpression iOS自带的正则表达式
- C# 网上下载文件或图片
- jquery html() 方法,在ie下与火狐谷歌兼容问题
- java 彻底理解 byte char short int float long double (转)