MySQL [ERR] 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

  sre

[SQL] Query wordpress start
[ERR] 1153 - Got a packet bigger than 'max_allowed_packet' bytes

MySQL默认读取执行的SQL文件最大为16M,SQL文件过大执行不过去
在件my.cnf的[mysqld]下面添加一句话:

max_allowed_packet=512M

重启MySQL服务即可

LEAVE A COMMENT

Captcha Code