The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

increase max_allowed_packet

Discussion in 'General Discussion' started by sado.buzz, May 19, 2015.

  1. sado.buzz

    sado.buzz Registered

    Joined:
    May 19, 2015
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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!
     
  2. lldeepakll

    lldeepakll Well-Known Member

    Joined:
    May 20, 2012
    Messages:
    85
    Likes Received:
    2
    Trophy Points:
    58
    Location:
    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
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,436
    Likes Received:
    1,215
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  4. sado.buzz

    sado.buzz Registered

    Joined:
    May 19, 2015
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Paris
    cPanel Access Level:
    Website Owner
    Solved, Tank You :)
     
Loading...

Share This Page