您好,登錄后才能下訂單哦!
小編給大家分享一下mysql提示got timeout reading communication packets怎么辦,相信大部分人都還不怎么了解,因此分享這篇文章給大家參考一下,希望大家閱讀完這篇文章后大有收獲,下面讓我們一起去了解一下吧!
錯(cuò)誤提示:
user: 'root' host: `localhost' (Got timeout reading communication packets)
MYSQL server has gone away
引起這個(gè)原因是不可怕的.原因是更改了系統(tǒng)的斷開時(shí)間.
mysql>show gloable variables like "%timeout%";
進(jìn)行查看
interactive_timeout 的黓認(rèn)值為28800
wait_timeout 的默認(rèn)值這:120
根據(jù)情況增加吧.
這兩個(gè)值是一個(gè)全局變量,可以動(dòng)態(tài)增加,如:
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)
可以導(dǎo)致Got timeout reading communication packets錯(cuò)誤的原因
https://dev.mysql.com/doc/refman/5.5/en/communication-errors.html
可能導(dǎo)致Got Timeout reading communication packets錯(cuò)誤的原因有如下幾個(gè):
A client attempts to access a database but has no privileges for it.(沒有權(quán)限)
A client uses an incorrect password.(密碼錯(cuò)誤)
A connection packet does not contain the right information.(連接沒有包含正確信息)
It takes more than connect_timeout seconds to obtain a connect packet. (獲取連接信息起過connect_timeout的時(shí)長)
The client program did not call mysql_close() before exiting.(客戶端沒有調(diào)用mysql_close()函數(shù))
The client had been sleeping more than wait_timeout or interactive_timeout seconds without issuing any requests to the server. (客戶端的空連接時(shí)間過長,超過了wait_timeout和interactive_timeout的時(shí)間)
The client program ended abruptly in the middle of a data transfer.(數(shù)據(jù)傳輸過程中終結(jié))
錯(cuò)誤排查:
因?yàn)槲覀兪謾C(jī)版與pc端的php函數(shù)不同步導(dǎo)致的問題,所以仔細(xì)檢查一下問題就解決了。
以上是“mysql提示got timeout reading communication packets怎么辦”這篇文章的所有內(nèi)容,感謝各位的閱讀!相信大家都有了一定的了解,希望分享的內(nèi)容對(duì)大家有所幫助,如果還想學(xué)習(xí)更多知識(shí),歡迎關(guān)注億速云行業(yè)資訊頻道!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。