Mysql导入Error Code: 2013 - Lost connection to MySQL server during query

2019独角兽企业重金招聘Python工程师标准>>>

首先查看WIN+R,调出services.msc,打开服务对话框:

搜索Mysql的服务,右键--->属性,查看mysql的ini文件的路径:

不利用服务来搜索MYSQL执行文件路径很容易找错地方,我上次就找了个mydefault.ini文件,结果怎么捣鼓都不对

在该文件下搜索"max_allowed_packet",在搜索处加入:

lower_case_table_names = 1
wait_timeout=2880000
interactive_timeout = 2880000
max_allowed_packet = 50M

在导入的SQL文件中如果有函数,可能会报错:

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de....

此时在SQLYOG中执行:

set global log_bin_trust_function_creators=TRUE;

 

转载于:https://my.oschina.net/u/2331760/blog/853499