Solve the problem of Got a packet bigger than 'max_allowed_packet' bytes

mysql5.7 query data throws the above exception, the solution:
modify the mysql configuration filemax_allowed_packetvalue, make the value larger. If this configuration does not exist in the configuration file, manually add it under the mysqld item.

example:max_allowed_packet = 16M

This parameter is used to limit the size of data packets received by mysql server, the maximum value is 1G

Related: Solve the problem of Got a packet bigger than 'max_allowed_packet' bytes