MySQL Packets larger than Max_allowed_packet is not allowed

A system parameter for MySQL: Max_allowed_packet, whose default value is 1048576 (1M),
Enquiry: Show VARIABLES like '%max_allowed_packet% ';
Modify the value of this variable: "Max_allowed_packet = 1M" In the [Mysqld] section of the My.ini file in the MySQL installation directory, such as change to 4M (if there is no line of content, add one row), save, restart the MySQL service. It is now possible to load files larger than 1M.

MySQL restricts the size of packets accepted by the server according to the configuration file.

Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, resulting in failure.

View current configuration

Show VARIABLES like '%max_allowed_packet% ';

The results shown are:

+--------------------+---------+

| variable_name | Value |

+--------------------+---------+

| Max_allowed_packet | 1048576 |

+--------------------+---------+

The above description is currently configured to: 1M

Modify method

1) Workaround

Modify the MySQL installation directory My.ini or My-default.ini to modify, add in the [Mysqld] Segment

Max_allowed_packet = 20M

MySQL Packets larger than Max_allowed_packet is not allowed