ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization pa

最新推荐文章于 2021-06-09 10:35:43 发布

原创最新推荐文章于 2021-06-09 10:35:43 发布 · 352 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

mysql 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了解决数据库连接超时问题的方法。通过调整 connect_timeout 参数，可以有效避免因客户端与服务器初次连接时出现的超时错误。文章首先展示了如何查看当前的 connect_timeout 设置，并提供了增加该参数值的具体 SQL 语句。

Discussion

This error can happen when the client is attempting an initial connection to the server. If your connect_timeout value is set to only a few seconds, you may be able to resolve the problem by increasing it.

Solution

Before increasing the value of connect_timeout, first determine its current value. This can be done by executing the following SQL statement:

SHOW VARIABLES LIKE 'connect_timeout';

+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| connect_timeout |  2    | 
+-----------------+-------+

Normally, setting this variable to ten seconds would be sufficient. You might want to set it to more than ten seconds if you have a very long distance or slow connection. You can determine whether you are experiencing this more uncommon cause by using the following SQL statement:

SHOW STATUS like 'aborted_connections';

This statement usually will return an empty set. However, if you have been experiencing aborted connections, the value will increase by one for each initial connection attempt that the server aborts.

To change this value of connect_timeout, you can use the SET statement. You will need SUPER privileges.