MySql Error Code: 2006

Posted on

Question :

Good morning,

I’m using MySql Bank WorkBeanch 6.3.5, the connection is ok, but when I do a simple select on any table it gives the following error:

Error Code: 2006. MySQL server has gone away


Answer :

The problem can be in the MySQL configuration. In the my.cnf file in Linux or my.ini in Windows look for and leave this line like this:

max_allowed_packet = 16 M

Increasing the capacity of max_allowed_packet in my.cnf (in [mysqld]) to 8 or 16M fixes this.


Leave a Reply

Your email address will not be published. Required fields are marked *