ballhogjoni Posted April 1, 2016 Share Posted April 1, 2016 I just installed mysql 5.1.73 on centos 6.7 and I get this error literally every time I hit enter. I've tried max_allowed_packet=500M and wait_timeout=28000 and restarting the server with neither helping. mysql> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 1 Current database: *** NONE *** Quote Link to comment https://forums.phpfreaks.com/topic/301128-i-get-the-mysql-server-has-gone-away-every-command-i-enter/ Share on other sites More sharing options...
benanamen Posted April 1, 2016 Share Posted April 1, 2016 (edited) Try setting max_allowed_packet to 1048576. This is a known problem in that version of Cent OS. If you can, upgrade to CentOS version 7. Did you do a manual Mysql install or from package? If you did manual, you are probably going to have additional problems after the max packet fix but lets see where you are at after the packet increase. Edited April 1, 2016 by benanamen Quote Link to comment https://forums.phpfreaks.com/topic/301128-i-get-the-mysql-server-has-gone-away-every-command-i-enter/#findComment-1532669 Share on other sites More sharing options...
Barand Posted April 1, 2016 Share Posted April 1, 2016 see http://dev.mysql.com/doc/refman/5.7/en/gone-away.html Quote Link to comment https://forums.phpfreaks.com/topic/301128-i-get-the-mysql-server-has-gone-away-every-command-i-enter/#findComment-1532675 Share on other sites More sharing options...
benanamen Posted April 1, 2016 Share Posted April 1, 2016 OP is about thirty eight (38) versions of mysql behind. The issue in that version of Cent OS has been fixed. He will need to update his sources list and update from the package manager but there could still be an issue because the mysql config path was moved. Quote Link to comment https://forums.phpfreaks.com/topic/301128-i-get-the-mysql-server-has-gone-away-every-command-i-enter/#findComment-1532696 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.