Packets larger than max_allowed_packet are not allowed

Mysql Packets larger than max_allowed_packet are not allowed error occured during the bulk insert operation. 

The Error like.

**Solution(s)** 

The value of max_allowed_packet you see with the command

show variables like 'max_allowed_packet';

Set Commands:

Max_allowed_packet=100M - include the my.ini file.

Max_allowed_packet=100M

(Or)

Set Query, without requiring server restart.

Execute Query:

SET GLOBAL max_allowed_packet=100M

(Or)

This sets it to bytes 

set global max_allowed_packet = 1000000000