In MySQL, you might run into the error 1153, where it said: “Got a packet bigger than ‘max_allowed_packet’ bytes”.

To fix this, you have to modify the max_allowed_packet size and make it bigger.

From the query editor:

SET GLOBAL max_allowed_packet=100000;

From the command line:

mysql --max_allowed_packet=100M

Or modify the file my.ini or my.cnf and put this line under [mysqld] section in your file:


The size is up to you, the bigger it is, the bigger packet size is allowed. The largest possible packet that can be transmitted to or from a MySQL 8.0 server or client is 1GB. You can see more from the documentation.

Need a good GUI Tool for MySQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.

Download TablePlus free.

TablePlus GUI Tool MySQL