mysql数据导入的时候提示Got a packet bigger than 'max_allowed_packet' bytes

Got a packet bigger than 'max_allowed_packet' bytes错误

默认可能是2M

把max_allowed_packet设置大于5M试试，我设置为160M，输入命令

mysql>set global max_allowed_packet = 1024*1024*160;

即可解决此问题