Got a packet bigger than 'max_allowed_packet' bytes
Database 2024/10/15 12:34:22 点击:不统计
mysql执行sql 文件出现提示 Got a packet bigger than 'max_allowed_packet' bytes 这个是执行sql 数据文件是,提示加载数据文件过大
解决方案如下:
1. 设置当前会话修改, 服务器重启后会失效
SET GLOBAL max_allowed_packet = 16777216; -- 16MB, adjust size as needed
2. 临时设置当前连接, 重新连接后会失效
SET max_allowed_packet = 16777216; -- 16MB, adjust size as needed
3. 设置永久配置,在my.cnf 中配置如下,修改后要重启mysql
[mysqld]
max_allowed_packet=16M
上面就是修改 max_allowed_packet配置的过程。转www.载for网站制作学习asp必.cn究