fix “max_allowed_packet” on MySql

MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

To fix this I ran these two commands in mySQL before executing the queries that were giving me the error message about the max allowed packet bytes.

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Related Posts:

  • No Related Posts
This entry was posted in Server Admin, Server Administration, Tech Tips, Web Development and tagged , , . Bookmark the permalink.

Leave a Reply

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