mysql报错Got an error reading comm
2019-10-09 本文已影响0人
无处安放的躁动
现象
2019-10-09T08:33:45.388854Z 414 [Note] Aborted connection 414 to db: 'database' user: 'username' host: '192.168.0.103' (Got an error reading communication packets
临时配置解决办法
# 设置最大包大小
set global max_allowed_packet = 1024*1024*1024;
# 查看包大小
show variables like '%max_allowed_packet%';
永久配置解决办法
[mysqld]
max_allowed_packet=256M
