mysql提⽰gottimeoutreadingcommunicationpackets的解
决⽅法
错误提⽰:
user: 'root' host: `localhost' (Got timeout reading communication packets)
MYSQL server has gone away
引起这个原因是不可怕的.原因是更改了系统的断开时间.
手机mysql安装配置教程mysql>show gloable variables like "%timeout%";
进⾏查看
h5特效代码大全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";
+---------------------+-------+
安卓属于linux系统吗| 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()函数)
scanf用法go语言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.(数据传输过程中终结)
错误排查:
kotlin单例
ajax代码一般写在哪里因为我们⼿机版与pc端的php函数不同步导致的问题,所以仔细检查⼀下问题就解决了。
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。
发表评论