Results 1 to 6 of 6

Thread: edit my.cnf

  1. #1
    Registered User
    Join Date
    Feb 2011
    Posts
    2

    Default edit my.cnf

    I own an unmanaged LINUX VPS with cpanel



    in one websie i'm getting following error

    Invalid query: Got a packet bigger than 'max_allowed_packet' bytes

    Where to edit and how to edit through whm

  2. #2
    Registered Member ultimatehosting's Avatar
    Join Date
    Jul 2011
    Location
    India
    Posts
    11
    cPanel Access Level

    Root Administrator

    Default Re: edit my.cnf

    You need to edit my.cnf as root and increase the value of max_allowed_packet as per your requirements.

  3. #3
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel Access Level

    Root Administrator

    Default Re: edit my.cnf

    The file is at /etc/my.cnf in root SSH, since the full path wasn't noted previously. Upon making any changes to /etc/my.cnf file, please restart MySQL for those changes to take effect.
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  4. #4
    Registered Member ultimatehosting's Avatar
    Join Date
    Jul 2011
    Location
    India
    Posts
    11
    cPanel Access Level

    Root Administrator

    Default Re: edit my.cnf

    Quote Originally Posted by cPanelTristan View Post
    The file is at /etc/my.cnf in root SSH, since the full path wasn't noted previously. Upon making any changes to /etc/my.cnf file, please restart MySQL for those changes to take effect.
    Oops I missed that, thanks for stepping in and providing the OP with the complete path.

    Fully Managed Services

  5. #5
    Registered User
    Join Date
    Dec 2012
    Posts
    1
    cPanel Access Level

    DataCenter Provider

    Default Re: edit my.cnf

    Hello people!

    I see this forum gives some information; however, its seems to be lacking easy steps for a beginner. I have an article on this that shows how to cat, nano, and view through shell the my.cnf settings.

    /http://www.inmotionhosting.com/support/website/general-server-setup/edit-mysql-my-cnf

    The my.cnf may not have the setting in it when you view it through shell.

    Viewing the MySQL variables through shell.
    1. Login to your server via SSH

    1. Type the following command: myasqladmin variables

    You can also view the settings for MySQL in PhpMyAdmin.
    1. Log into your phpMyAdmin

    1. Click the Variables tab at the top right.


    That way you can get the exact MySQL settings available to edit in the my.cnf as well.

    Regards,
    James R


    Quote Originally Posted by ultimatehosting View Post
    Oops I missed that, thanks for stepping in and providing the OP with the complete path.

  6. #6
    Registered Member linux7802's Avatar
    Join Date
    Dec 2007
    Posts
    232
    cPanel Access Level

    Root Administrator

    Default Re: edit my.cnf

    I would like to recommend you, if you are not sure about correct mysql parameter for your server which will increase the server performance then run the mysqltunner and make the necessary changes in the my.cnf file but make sure that you have taken a backup for the original my.cnf file. The incorrect values in the my.cnf file can cause the major problem to your server performance, so be careful while making changes.

Similar Threads

  1. How to edit the my.cnf
    By jyhqp in forum Database Discussions
    Replies: 5
    Last Post: 09-14-2013, 11:11 AM
  2. How to edit the my.cnf
    By jyhqp in forum General Discussion
    Replies: 3
    Last Post: 04-22-2013, 09:26 PM
  3. Unable to edit my.cnf
    By ktangxd in forum Database Discussions
    Replies: 1
    Last Post: 05-04-2012, 12:25 AM
  4. User cant edit mysql and cant edit password pro directory access
    By Custom-Hosting in forum General Discussion
    Replies: 1
    Last Post: 01-18-2006, 07:30 PM
bargain