2006 - MySQL server has gone away

错误信息"2006 - MySQL server has gone away"表示MySQL服务器连接已断开。这种情况通常发生在执行大型SQL文件时，其中的查询超过了MySQL服务器的最大包大小。默认情况下，客户端和服务器的最大包大小都是16M。解决这个问题的一个方法是增大max_allowed_packet参数的值。可以通过执行"show global variables like 'max_allowed_packet';"命令来查看当前的max_allowed_packet值。然后，可以通过修改配置文件或者在SQL会话中使用SET命令来增大这个值。另外，也可以考虑调整net_buffer_length参数的值，以便更好地适应大型SQL文件的执行。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [2006 - MySQL server has gone away](https://blog.csdn.net/qq_43753724/article/details/120822889)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *3* [MySQL教学源码-MySQL入门教程.zip](https://download.csdn.net/download/qq_53122658/88218729)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]