Got a packet bigger than 'max_allowed_packet' bytes"

If you are getting this error via root SSH access, please use the following command to verify if the setting is already defined:


# grep -i max_allowed_packet /etc/my.cnf

 

If the setting is not yet defined (i.e., no output from the above command) then the option could be inserted manually into the MySQL configuration (my.cnf) file using your preferred command-line text editor.

The following may be used as an example for what to add (under the configuration section labeled "[mysqld]"):

# max_allowed_packet = 1M

 
 
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Run OPTIMIZE TABLE to defragment tables for better performance

For this suggestion:Run OPTIMIZE TABLE to defragment tables for better performanceRun this...

How to clear Error Log of a cPanel Account.

User the below code to clear Error Log:Replace User with Username:Code:for i in `find...

What is php.ini ?

The php.ini file and changing PHP Settings The php.ini file is a special file for PHP and...

How to fix ini_set() has been disabled for security reasons

1. Create php.ini file inside your public_html folder, OR the folder in which you have...

How to fix Fatal error: Uncaught exception 'Exception' with message 'DateTimeZone:

1: Create .htaccess file inside your public_html folder, OR the folder in which you have...