How to change max_allowed_packet value?

[Divvy]

Hello friends,

Can someone of you tell me what is the SSH command to change the max_allowed_packet value? Please?

By doing this command:

mysql> show variables like '%max_allowed_packet%';

Appears:

+--------------------+---------+
| Variable_name | Value |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+
1 row in set (0.00 sec)

That is 1MB right?

I need to change to 32MB

Anyone?

Divvy Reviewed by Divvy on 17th Jan 2011. How to change max_allowed_packet value? Hello friends, Can someone of you tell me what is the SSH command to change the max_allowed_packet value? Please? By doing this command: mysql> show variables like '%max_allowed_packet%'; Appears: Rating: 5

[warezrock]

open my.cnf file which is normally in /etc/my.cnf
you can open the file with the following ccommand

nano /etc/my.cnf
or
vi /etc/my.cnf

check the value max_allowed_packet in the file if not found
just add the following line in the my.cnf

max_allowed_packet = 32M

and restart the mysql

service mysqld restart

[Divvy]

Thank you mate

[warezrock]

Thank you mate

np mate anytime