MySQL“#2006 - MySQL服务器已经消失”在phpMyAdmin [英] MySQL "#2006 - MySQL server has gone away" in phpMyAdmin

查看:588
本文介绍了MySQL“#2006 - MySQL服务器已经消失”在phpMyAdmin的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

问题

我的MySQL数据库适用于我的Web应用程序。但是,当我尝试使用phpMyAdmin打开数据库时,我收到以下错误消息:

My MySQL database works fine for my web application. However, when I try to open the database with phpMyAdmin, I get this error message:

#2006 - MySQL server has gone away

并且phpMyAdmin断开连接到登录屏幕。其他数据库工作正常。
我的 ax_allowed_pa​​cket 设置为16.我也尝试了64,但没有工作。

And phpMyAdmin disconnects back to the login screen. Other databases work fine. My ax_allowed_packet is set to 16. I also tried 64, but it didn't work.

这个错误最终发生了。数据库的大小约为3 MB,所以不是很大。

Also this error occured eventually. The database is about 3 MB in size, so not very big.

已使用的软件


  • Debian Squeeze x64

  • MySQL(当前版本)

  • phpMyAdmin(当前版本)

问题

如何解决此错误,以便再次查看和编辑我的数据库在phpMyAdmin?

How can I fix this error in order to view and edit my database in phpMyAdmin again?

推荐答案

我终于找到了。

显然,升级到MySQL 5.6后有一些不兼容问题。

Apparently, there were some incompatibility issues after upgrading to MySQL 5.6.

为了检查这些问题并修复它们,您将需要执行MySQL升级。

In order to check for such issues and fix them, you will need to do a MySQL Upgrade.

只需在终端上运行以下命令:

Just run the following on a terminal:

mysql_upgrade -u root -p

输入您的密码,等待升级完成。

Enter your password, and wait until the upgrade finishes.

这解决了我的问题。

这篇关于MySQL“#2006 - MySQL服务器已经消失”在phpMyAdmin的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆