Maximum Packet Size

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

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.

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


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

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

sudo systemctl restart mariadb