MySQL报错：【Packet for query is too】【large max_allowed_packet】

## 查询系统字符集
SHOW VARIABLES LIKE '%character%';
## 查询MySQL接收数据表的大小
SHOW VARIABLES LIKE '%max_allowed_packet%';

## 方法1、设置为1g
SET GLOBAL max_allowed_packet = 1*1024*1024*1024;
SET GLOBAL slave_max_allowed_packet = 1*1024*1024*1024;

## 方法2、修改my.cnf配置文件
max_allowed_packet = 1g
slave_max_allowed_packet = 1g

## 设置完之后退出登录重新查看
SHOW VARIABLES LIKE '%max_allowed_packet%';