blocks|key|679161|text|调查显示，许多解决方案正确地讨论了在my.cnf中设置mysql的max_allowed_packet和wait_timeout；小附录表明，mac上的mysql默认安装似乎不包括此文件。您可能首先需要在/etc/my.cnf创建它(如果您使用的是mysql的默认安装，而不是mamp堆栈或类似的安装，这只是一个问题)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|679162|为我更正此问题的/etc/my.cnf的内容如下：|679163|[mysqld]
max_allowed_packet=+64M
wait_timeout=+6000|code-block|syntax|javascript|679164|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Investigation shows many solutions correctly talking about setting the max_allowed_packet and wait_timeout for mysql in my.cnf; small addendum that the default install of mysql on mac osx doesn't appear to include this file. You may first need to create it at /etc/my.cnf (this is only an issue if you're using the default install of mysql instead of a mamp stack or similar)

contents of /etc/my.cnf that corrected this issue for me below:

<pre><code>[mysqld]
max_allowed_packet= 64M
wait_timeout= 6000
</code></pre>

blocks|key|896052|text|如果您的INSERT查询是一个包含多行的太大的单行语句，这种情况经常会发生。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|896053|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It often happens, if your INSERT query is a too big single line statement with several rows.

blocks|key|896219|text|尝试重新启动mysql服务器。可能是服务器不能正常工作，但sql通知程序也在显示正在运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|896220|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Try to restart mysql server. It`s possible that server is not working correctly but sql notifier displaying that is running, as well.

blocks|key|896337|text|我尝试了所有的解决方案，但都不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|896338|我使用工作台远程连接hostgator|896339|我意识到mysql服务器hostgator是5.5版本，而在我的工作台中设置为5.6版本|896340|当我将工作台设置为5.5时，他开始工作|896341|编辑/preferences/mysql/default目标版本|896342|📷|atomic|offset|length|896343|​|896344|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/656d639e6cb7c5cf4b6522b7dc685913.gif|imageAlt^0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|12|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|13|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|14|8|@]|9|@$M|15|N|16|1|17]]|A|$]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X|Y|-4]]]]

I tried all the solutions and nothing worked 
I use the workbench to remotely connect hostgator 
I realized that mysql server hostgator was the 5.5 version and in my workbench is set up to version 5.6 
when I set the workbench to 5.5 he started to work 

edit/preferences/mysql/default target version 
<a href="https://i.stack.imgur.com/IyT2V.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IyT2V.gif" alt="enter image description here"></a>

blocks|key|679369|text|这个问题发生在你身上的原因有很多，你可以找到所有可能的原因，就我个人而言，我一直在为数据包的大小而苦苦挣扎，但我已经更新了我的my.ini文件，但在此之前，我检查了给我1048576B+=+1MB的max_allowed_packet变量，我已经更新到5MB。显示variable_name喜欢'%25packet%25‘的变量|type|unstyled|depth|inlineStyleRanges|entityRanges|data|679370|选择1048576+/+1024+/+1024|679371|选择5242880+/+1024+/+1024|679372|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

there are many reason that this issue is happening to you, <a href="http://dev.mysql.com/doc/refman/5.0/en/gone-away.html" rel="nofollow">here</a> you can find all of the possible reasons, personally I've been struggling with the packet size but I've updated my my.ini file 
but before to do that, I've checked the max_allowed_packet variable that had given me 1048576B = 1MB
and I've updated to 5MB.
show variables where variable_name like '%packet%'

select 1048576 / 1024 / 1024

select 5242880 / 1024 / 1024

blocks|key|896378|text|正如都铎在他的反应中提到的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|896379|+The+most+common+reason+for+the+MySQL+server+has+gone+away+error+is+that+the+
+server+timed+out+and+closed+the+connection|code-block|syntax|javascript|896380|您需要更改最大执行时间和大小，您可以使用以下命令进行更改：|896381|SET+GLOBAL+wait_timeout+=+6000;
SET+GLOBAL+max_allowed_packet=+64M;|896382|它们是sql命令，因此您可以像noramal命令一样执行它们。|896383|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

AS mentioned by Tudor in his reaction:

<pre><code> The most common reason for the MySQL server has gone away error is that the 
 server timed out and closed the connection
</code></pre>

You need to change the maximum execution time and size 
you can use the following commands to do so:

<pre><code>SET GLOBAL wait_timeout = 6000;
SET GLOBAL max_allowed_packet= 64M;
</code></pre>

They are sql commands so you can execute them like noramal commands.

blocks|key|679578|text|这种情况时有发生，你的服务器处于离线状态，而你正在使用密码更改前创建的MySQL连接，这就是为什么你应该在服务器密码更改后创建一个新的连接并使用SQL练习。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|679579|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

it happens sometimes, those at your server are offline and you are using MySQL connection it was created before password changed.that's why you should create a new connection and use of SQL practice after the server password changed.

blocks|key|896438|text|当我尝试在表的末尾添加一列时，我发现在使用MySQL+Workbench+8.0的SQL中，这种情况经常发生。此外，该表将被锁定且不可用。然后，直到一两天后，尝试删除该表才起作用。然而，我发现当我在现有列之间插入一个新列时，我看不到任何问题...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|896439|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I'm finding this is happening a lot in My SQL using MySQL Workbench 8.0 when I try to add a column at the end of my table. In addition, the table is then locked and unusable. Trying to drop the table then doesn't work until a day or two later. I have found, however, that I see no problems when I insert a new column between existing columns...

blocks|key|679665|text|如果您的INSERT查询是一个包含多行的过大的单行语句。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|679666|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If your INSERT query is a too big single line statement with several rows.

I am getting following error, when I try to import MYSQL database:

<pre><code>Error Code: 2013 - Lost connection to MySQL server during queryQuery:
Error Code: 2006 - MySQL server has gone away
</code></pre>

Can someone let me know what is wrong?

Getting MYSQL Error: "Error Code: 2006 - MySQL server has gone away"

SQL数据库

数据库

服务器

MySQL

当我尝试导入MYSQL数据库时，我收到以下错误：Error Code: 2013 - Lost connection to MySQL server during queryQuery:Error Code: 2006 - MySQL server has gone away有没有人能告诉我出了什么问题？

问获取MYSQL错误：“错误代码: 2006 - MySQL服务器已离开”
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问获取MYSQL错误：“错误代码: 2006 - MySQL服务器已离开”EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问获取MYSQL错误：“错误代码: 2006 - MySQL服务器已离开”
EN