Mysql Setting - how do I change it??

[SEOvB]

Originally Posted by Lulubelle

Hi

I'm pretty sure that this has been asked already but done a search and couldn't find anything in the forums.

I have a max_allowed_packets error when uploading attachments.

I have googled my heart out trying to find out how to change this. When I follow the directions given it doesn't work.

I SSH onto my server and type a mysql command - tried this but it came back with an authentication error despite using the root login.

I change the my.cnf file in the /etc folder manually by editing it in notepad++ - which is something else suggested but there is no setting in that file for max packet upload.

I am not technical but I do need to change this setting myself, can someone give me an idiot proof way of doing this please?

Help would be very much appreciated

Don't edit system files in notepad++ or notepad or anything like that, most of them can save extra characters or cause errors in the files.

Use nano or pico to edit the files, and make sure to back them up first before making changes.

cp my.cnf my.cnf.bak

Then when you restart mySQL if you have errors, you can simply copy the old working one back over the broken one with

cp my.cnf.bak my.cnf

Lynne gave the correct code for changing the setting you need to change so good luck.