项目场景:
导入sql文件报错
解决方案:
方法1
D:\mysql\mysql-5.7.35-winx64
修改 my.ini 文件
max_allowed_packet = 314572800
方法2
win+R
cmd
mysql -uroot -p
show global VARIABLES like ‘%max_allowed_packet%’;
set global max_allowed_packet = 314572800;
//show VARIABLES like ‘%max_allowed_packet%’;
//set global max_allowed_packet = 10241024300;
方法3