Mysql 显示错误 Got a packet bigger than 'max_allowed_packet'

操作系统是 Ubuntu 16.04,数据库操作显示错误:

PDOException: SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than ‘max_allowed_packet’

修改 my.cnf

sudo vi /etc/mysql/my.cnf

增加如下内容:

[mysqld]
max_allowded_packet = 32M

重启数据库:

sudo /etc/init.d/mysql restart

错误就消除了。


版权声明:本文为henryhu712原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。