MySQL 1153、2006错误 MySQL server has gone away
MySQL导入数据时出现以下错误:
Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes
Error Code: 2006 - MySQL server has gone away
解决方法:
找到MySQL安装目录下的my.ini
在 [mysqld] 下增加一行max_allowed_packet=16M 数值按需求更改
然后重启MySQL服务
开始 》 运行 net stop mysql net start mysql
Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes
Error Code: 2006 - MySQL server has gone away
解决方法:
找到MySQL安装目录下的my.ini
在 [mysqld] 下增加一行max_allowed_packet=16M 数值按需求更改
然后重启MySQL服务
开始 》 运行 net stop mysql net start mysql