• Skip to primary navigation
  • Skip to main content
  • Skip to footer
  • Home
  • Blog
  • Search

Kevin Dees

Full-Stack PHP Development

  • Twitter
  • Github
  • LinkedIn
You are here: Home / Fix / Fixing MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

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

February 19, 2020 by Kevin Leave a Comment

To fix, “MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes” on Ubuntu edit your /etc/mysql/mysql.conf.d/mysqld.cnf.

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Once you have opened the file, increase the max_allowed_packet to a value that works for your environment. For example, in a local development environment, 100M can work.

max_allowed_packet=100M

Then restart MySQL.

sudo service mysql restart

Resources

  • https://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes

Filed Under: Fix, SQL, Web

Reader Interactions

Leave a Reply Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Footer

Get Dare To Code

Get the latest on full-stack PHP development in your inbox with a bi-weekly lesson from Kevin Dees.

Copyright © 2021 · Kevin Dees · Log in