Mysql导入数据报错SQL Error(1153)详解数据库

MYSQL Error(1153): Got a packet bigger than ‘max_allowed_packet’ bytes

1.在终端中使用MySQL的root用户登录MySQL;

2.执行命令：

set global max_allowed_packet=1000000000; 
set global net_buffer_length=1000000; 
FLUSH PRIVILEGES; 

原文链接：IT虾米网