错误提示：
user: 'root' host: `localhost' (got timeout reading communication packets)
mysql server has gone away
引起这个原因是不可怕的．原因是更改了系统的断开时间．
mysql>show gloable variables like "%timeout%";
进行查看
interactive_timeout 的黓认值为28800
wait_timeout 的默认值这：120
根据情况增加吧．
这两个值是一个全局变量，可以动态增加，如：
mysql> set global interactive_timeout=28800;
query ok, 0 rows affected (0.00 sec)
mysql> show global variables like "interactive_timeout";
+---------------------+-------+
| variable_name | value |
+---------------------+-------+
| interactive_timeout | 28800 |
+---------------------+-------+
1 row in set (0.00 sec)
可以导致got timeout reading communication packets错误的原因
可能导致got timeout reading communication packets错误的原因有如下几个：
a client attempts to access a database but has no privileges for it.（没有权限）
a client uses an incorrect password.(密码错误)
a connection packet does not contain the right information.(连接没有包含正确信息)
it takes more than connect_timeout seconds to obtain a connect packet. (获取连接信息起过connect_timeout的时长)
the client program did not call mysql_close() before exiting.(客户端没有调用mysql_close()函数)
the client had been sleeping more than wait_timeout or interactive_timeout seconds without issuing any requests to the server. (客户端的空连接时间过长，超过了wait_timeout和interactive_timeout的时间)
the client program ended abruptly in the middle of a data transfer.(数据传输过程中终结)
错误排查：
因为我们手机版与pc端的php函数不同步导致的问题，所以仔细检查一下问题就解决了。
如对本文有疑问， 点击进行留言回复！！
我要评论
网友评论