I get the mysql server has gone away every command i enter

[ballhogjoni]

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 ***

[benanamen]

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

[Barand]

see

 

http://dev.mysql.com/doc/refman/5.7/en/gone-away.html

[benanamen]

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.