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
- Mysql mysql lost connection to server during query 問題解決方法MySqlServer
- mysqldump: Error 2013: Lost connection to MySQL server during query when dumpingMySqlErrorServer
- MySQL報錯ERROR 2013 (HY000): Lost connection to MySQL server during queryMySqlErrorServer
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- MySQL異常刨析：ata source rejected establishment of connection, message from server: “Too many connectionMySqlServer
- Spring Authorization Server（AS）從 Mysql 中讀取客戶端、使用者SpringServerMySql客戶端
- Blazor Server完美實現Cookie Authorization and AuthenticationBlazorServerCookie
- Spring Authorization Server 實現授權中心SpringServer
- Spring Authorization Server 正式遷移到 spring-projectsSpringServerProject
- [network][easy case]troubleshoting the connection to a remote serverREMServer
- spring-authorization-server令牌放發原始碼解析SpringServer原始碼
- Spring Authorization Server授權伺服器入門SpringServer伺服器
- Check connection related issue of mysqlMySql
- Spring Authorization Server 0.3.0 釋出，官方文件正式上線SpringServer
- Spring Authorization Server 0.2.3釋出，放出聯合身份DEMOSpringServer
- ASP.NET Core3.1使用Identity Server4建立Authorization Server-2ASP.NETIDEServer
- ASP.NET Core3.1使用Identity Server4建立Authorization Server-1ASP.NETIDEServer
- The last packet successfully received from the server was 2,625 milliseconds ago.ASTServerGo
- Dr.Elephant mysql connection errorMySqlError
- 【故障處理】ORA-28547: connection to server failed, probableServerAI
- Establishing SSL connection without server's identity verification is not recommended.ServerIDE
- 總結SSH登陸故障:expected key exchange group packet form serverORMServer
- The connection to the server 10.10.0.2:6443 was refused - did you specify the right host or port?Server
- bug:1、the last packet sent successfully to the server was 0 milliseconds ago 2、avoid mutating a propASTServerGo
- “The last packet sent successfully to the server was 0 milliseconds ago. ”異常解決方案ASTServerGo
- MySQL報錯:Packets larger than max_allowed_packet are not allMySql
- Mysql 如何更改default collation_connection settingMySql
- 連線mysql報錯lost connect to sever during query解決MySql
- ssh連線遠端伺服器出現Host key verification failed. lost connection問題的解決伺服器AI
- Mysql資料庫的max_allowed_packet設定方法MySql資料庫
- MySQL Server Startup ScriptMySqlServer
- Mysql修改server uuidMySqlServerUI
- Redis Reading NotesRedis
- 技術分享 | MySQL：max_allowed_packet 影響了什麼？MySql
- It is the Auction House in Lost Ark
- nacos Connection refused (Connection refused)