Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

configuring mysql

Discussion in 'General Discussion' started by scotch33, Feb 16, 2009.

  1. scotch33

    scotch33 Member

    Nov 20, 2008
    Likes Received:
    Trophy Points:
    I am having problems with a particular site - documents are loaded into the databasec rather than as files (its a file repository).

    At the moment, if users try to upload more than a meg the system throws its toys.

    I have researched and believe the problem to be max_allowed_packet in mysql and thus need to edit this in the config. Is there a way to edit the mysql config and change this from WHM?

    If there is, where is it?
  2. JawadArshad

    JawadArshad Well-Known Member PartnerNOC

    Apr 8, 2008
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    DataCenter Provider
    I believe WHM does not have any feature to tweak mysql conf. You can do it from shell. Here is the syntax.

    root@server [~]# cat /etc/my.cnf
    set-variable = max_allowed_packet=xyzM

    xyz is any numeric value you want to set for this variable. Do not forget to restart mysql service after making this change.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice