Maximum Packet Size

Support and Discussion Database Server
1

Hello There!!!
How can increase max packet size of my server mysql database?
Or there is option for just a single site?

2

Run this command as root

find / -name my.cnf

I found 2 at /root/cyberpanel/install/mysql/my.cnf and /usr/local/CyberCP/install/mysql/my.cnf

The normal place is /etc/my.cnf but that is missing or empty on my instance with centos 7.

3

To edit Mysql max_allowed_packet type:
nano /etc/mysql/my.cnf
Then add max_allowed_packet=500M under [client-server]
To exit nano, press Ctrl+X and then Y and press Enter
After that remember to restart Mysql

service mysql restart

You can verify the changes going to PhpmyAdmin, then Variables

1 Like
4

Better:

@JonathanDHN told me to use: (copy all the 4 following lines in console)

sudo cat > /etc/mysql/mariadb.conf.d/50-custom.cnf <<EOF
[mysqld]
max_allowed_packet = 64M
EOF

THEN:
sudo systemctl restart mariadb