mysql5.7 数据导入报 Error Code: 2006

C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes

max_allowed_packet=500M

SHOW VARIABLES LIKE '%max_allowed_packet%';  

mysql --help | grep my.cnf

cp /usr/share/mysql/my-huge.cnf /etc/my.cnf #拷贝配置文件（注意：如果/etc目录下面默认有一个my.cnf，直接覆盖即可）

systemctl stop mariadb.service


systemctl start mariadb.service

Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes