LinkBack URL
About LinkBacksI 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
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
Re: edit my.cnf
You need to edit my.cnf as root and increase the value of max_allowed_packet as per your requirements.
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
Re: edit my.cnf
Oops I missed that, thanks for stepping in and providing the OP with the complete path.Originally Posted by cPanelTristan
Fully Managed Services
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.
- Login to your server via SSH
- Type the following command: myasqladmin variables
You can also view the settings for MySQL in PhpMyAdmin.
- Log into your phpMyAdmin
- 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
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.
Reply With Quote
