1. MySQL导入sql文件时报错: 2013 - Lost connection to MySQL server during query

a)经过百度得知,需要调大mysql的my.ini文件的max_allowed_packet参数大小

MySQL问题-LMLPHP

b)我使用的mysql5.7.1版本(C:\ProgramData\MySQL\MySQL Server 5.7\my.ini),使用了命令行的形式来修改

c)show global variables like '%timeout%';

d)set global max_allowed_packet = 268435456;

e)show global variables like '%timeout%';

f)set global net_read_timeout = 120;

g)set global net_write_timeout = 900;MySQL问题-LMLPHPMySQL问题-LMLPHP

09-15 04:15