-
Notifications
You must be signed in to change notification settings - Fork 22
MySQL 设置max_allowed_packet
L edited this page Dec 29, 2021
·
2 revisions
设置max_allowed_packet
分两种方式
1.及时生效,但重启后无效:set global max_allowed_packet = 1024102410
如果是docker的MySQL容器,需要先进入容器
docker exec -it mysql /bin/bash
然后进入MySQL指令
mysql -u root -p
输入密码
进行设置,这里是20M
set global max_allowed_packet = 20*1024*1024;
退出
exit
重启进入MySQL查询是否生效
mysql -u root -p
输入密码
show VARIABLES like '%max_allowed_packet%';
2.修改my.ini
或者~/.my.cnf
配置文件,重启MySQL后生效
[mysqld]
max_allowed_packet=20M
max_allowed_packet的最大值为1024M