[MySQL] How can I change "max_allowed_packet"?

[THOR]

Error Code: 2006 - MySQL server has gone away

• Start MySQL 5.5 Command Line Client
• At the command prompt, execute the foll. command

  mysql> show variables like 'max_allowed_packet';

___________________________

| Variable_name | Value |

___________________________

| max_allowed_packet | 1048576 |

___________________________

1 row in set (0.00 sec)

• At the command prompt, execute the foll. command

  mysql> set global max_allowed_packet = 130 * 1024 * 1024;

• Exit
• Start MySQL 5.5 Command Line Client
• At the command prompt, execute the foll. command

  mysql> show variables like 'max_allowed_packet';

_____________________________

| Variable_name | Value |

_____________________________

| max_allowed_packet | 136314880 |

_____________________________

1 row in set (0.00 sec)

This will set the global max packet size to 130 MB. All subsequent MySQL client connections will get this value as their session value for max packet

Now:

Source Database : information_schema

`GLOBAL_VARIABLES` VALUES ('MAX_ALLOWED_PACKET', '136314880');