ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 95
Posted by: Shane Furlong
Date: March 31, 2022 08:01AM

I am upgrading from MySQL 5.7.33 to MySQL 5.7.37 on a CentOS 7 server. For a minor upgrade, I normally accomplish this by removing the old binaries, replacing them with the new binaries, restarting mysqld and then logging in. However, my login fails with this error: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 95 I have seen some discussion about the problem on the internet, but have seen no usable solution. I understand the problem started with MySQL 5.7.34. Has anyone seen a solution to this problem? If you have, please, send me the link. if I add the following statement to my my.cnf file, I am able to login --skip-grant-tables This not a solution but it narrows the problem down to some change in the authentication process between version 5.7.33 and 5.7.34. Timeout settings: connect_timeout=10 delayed_insert_timeout=300 have_statement_timeout=YES innodb_flush_log_at_timeout=1 innodb_lock_wait_timeout=50 innodb_rollback_on_timeout=OFF interactive_timeout=28800 lock_wait_timeout=31536000 | net_read_timeout=30 net_write_timeout=60 rpl_stop_slave_timeout=31536000 slave_net_timeout=60 wait_timeout=28800 Abort results: Aborted_clients=4 Aborted_connects=60 When I try to login not skipping tables, the error result is instantaneous.This post looked promising, but had no solution: https://forums.mysql.com/read.php?132,696220,696220

Options: ReplyQuote


Subject
Written By
Posted
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 95
March 31, 2022 08:01AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.