How to modify the max_allowed_packet parameter of the mysql database

For example, errors such as "Got a packet bigger than 'max _ allowed_packet 'bytes" or "MySQL server has gone away" occur during Database Import, generally, the data imported is larger than the maximum package size limited by the system. The default max_allowed_packet value of the server is 1 MB. You can solve the problem by modifying the size of the 'max _ allowed_packet 'parameter.

The modification method is as follows:Go to the mysql installation directory, find the my. ini file, and add max_allowed_packet = * M at the bottom (set as needed.