2006 mysql 服务器已离线,MySQL“＃2006 - MySQL服务器已经消失”在phpMyAdmin

The Problem

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

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.

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

Used Software

Debian Squeeze x64

MySQL (current version)

phpMyAdmin (current version)

Question

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

解决方案

I finally found it.

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

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.

This fixed the problem for me.