max_allowed_packet set on server using WHM vps

anytime picture anytime · Sep 26, 2013 · Viewed 10.5k times · Source

I want to change max_allowed_packet on server using WHM vps.

but I am not getting at where it located, so please help me

I have tried

SET GLOBAL max_allowed_packet =1073741824;

but its not working its required super admin.

how to edit mysql.ini in WHM vps

same with httpd.conf, how to edit setting of apache in WHM ?

Answer

Citizen Kepler picture Citizen Kepler · Oct 7, 2013

Ahoy,

You can not edit the servers my.cnf file from inside WHM, you will need to edit this file using she ssh command line. To learn how to connect to your server using ssh please see:

http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/ShellAccess

Once you are connected to your server with the root login using ssh, you will want to issue the following command to edit my.cnf:

# nano -w /etc/my.cnf

In this file you will want to add a line under the [mysqld] section with the following contents:

max_allowed_packet=500M

You will now want to press Ctrl + O to save, and then Ctrl + X to exit. You will now want to restart the MySQL server through WHM or on the command line with:

 # /etc/init.d/mysql restart

This will update the max_allowed_packet for cPanel/WHM's mysql.