Lost connection to MySQL server at 'reading authorization packet'
Ubuntu 18.04 mysql 5.7.2
已經按照網上的做了下面的步驟,並重啟mysql 服務了,還是不行,不知道為啥。
1.大多數時候設定"set global connect_timeout=60;"是可以解決問題的。
我們可以透過執行“SHOWSTATUS LIKE 'aborted%'”,可以觀察到 Variable_name Value
Aborted_clients 6
Aborted_connects 15010
覺得是否要增加connect_timeout的時間,"Aborted_connects"將會隨著服務端放棄客戶端初始連線而增加。如果"Aborted_connects"很大,並且不斷增加,就需要增加"connect_timeout".
2.在MySQL的配置檔案中[mysqld]新增"skip-name-resolve",減少域名解析的時間
3.部署伺服器端的網路要好,至少大於100Mbps/s
4.如果是在呼叫mysql_query的時候出現的問題,那就需要把"net_read_timeout"的時間調成30秒,或者60秒,或者更大的值
5.如果還不能解決問題,那估計是你的SQL語句中含有BLOB這種大型別,我們就需要增加"max_allowed_packet"的值了
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-2691295/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL:Lost connection to MySQL server at 'readingMySqlServer
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization paErrorMySqlServer
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0 mysql遠端連線問題MySqlServerError
- Mysql連線錯誤:Lost connection to Mysql server at 'waiting for initial communication packet'MySqlServerAI
- Mysql mysql lost connection to server during query 問題解決方法MySqlServer
- mysql5.5_2013 Lost connection to Mysql server during queryMySqlServer
- MongoDB mongoimport 報錯:lost connection to serverMongoDBImportServer
- MySQL報錯ERROR 2013 (HY000): Lost connection to MySQL server during queryMySqlErrorServer
- mysqldump: Error 2013: Lost connection to MySQL server during query when dumpingMySqlErrorServer
- Percona MySQL 日誌中出現大量Aborted connection (Got an error reading)MySqlGoError
- Network Connection Lost When Windows 8 Goes To SleepWindowsGo
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- 使用Identity Server 4建立Authorization Server (3)IDEServer
- 使用Identity Server 4建立Authorization Server (2)IDEServer
- 使用Identity Server 4建立Authorization Server (1)IDEServer
- 使用Identity Server 4建立Authorization Server (5)IDEServer
- 使用Identity Server 4建立Authorization Server (4)IDEServer
- MYSQL CLENT/SERVER資料包傳輸及net packet buffer作用解析MySqlServer
- Spring Authorization Server(AS)從 Mysql 中讀取客戶端、使用者SpringServerMySql客戶端
- Blazor Server完美實現Cookie Authorization and AuthenticationBlazorServerCookie
- Connection/Session/Server ProcessesSessionServer
- MySQL異常刨析:ata source rejected establishment of connection, message from server: “Too many connectionMySqlServer
- 解決Redis/Codis Connection with master lost(複製超時)問題RedisAST
- ORA-03135: connection lost contact的解決方法
- Spring Authorization Server 實現授權中心SpringServer
- Mysql提示 “ Got a packet bigger than 'max_allowed_packet' bytes”MySqlGo
- mysql connection refusedMySql
- Spring Authorization Server 正式遷移到 spring-projectsSpringServerProject
- spring-authorization-server令牌放發原始碼解析SpringServer原始碼
- Spring Authorization Server授權伺服器入門SpringServer伺服器
- Slave: received 0 length packet from server, apparent master shutdownServerAPPAST
- Xlib: connection to ":0.0" refused by server(openSUSE)Server
- 使用Identity Server 4建立Authorization Server (6) - js(angular5) 客戶端IDEServerJSAngular客戶端
- MySQL ERROR Got an error reading communication packetsMySqlErrorGo
- Spring Authorization Server 0.2.3釋出,放出聯合身份DEMOSpringServer
- Spring Authorization Server 0.3.0 釋出,官方文件正式上線SpringServer
- Check connection related issue of mysqlMySql
- ASP.NET Core3.1使用Identity Server4建立Authorization Server-1ASP.NETIDEServer