increase max_allowed_packet

sado.buzz

Registered
May 19, 2015
4
0
1
Paris
cPanel Access Level
Website Owner
I just want to increase max_allowed_packet from my.cnf but i found it empty

Like that :

[mysqld]
innodb_file_per_table=1
bind-address=127.0.0.1

HELP plz!
 

lldeepakll

Well-Known Member
May 20, 2012
85
3
58
India
cPanel Access Level
Root Administrator
Hi,

You can add the following line under mysqld section in /etc/my.cnf file.

max_allowed_packet=268435456 (Enter desired value)

After adding restart mysql service.

Service mysql restart
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,258
463
Hello,

Yes, as mentioned, you can add the value if it does not yet exist. Ensure you restart MySQL after making any changes.

Thank you.