Got a packet bigger than 'max_allowed_packet' bytes,cpp mysql insert multiple values and e

You can also log into MySQL console and run the following command to set max_allowed_packet size for the duration of the session.

set global net_buffer_length=1000000; 
set global max_allowed_packet=1000000000;