mysql报错Got a packet bigger than ‘max_allowed_packet‘ bytes

mysql导入数据时出现Got a packet bigger than ‘max_allowed_packet’ bytes错误，如何解决？

可以先使用命令查看max_allowed_packet大小，一般这个值比较小

show variables like '%max_allowed_packet%' ;

如果修改为100M，则使用命令

SET GLOBAL max_allowed_packet=104857600;