phpMyAdmin - 错误您应该升级到 MySQL 5.5.0 或更高版本
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26222244/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
phpMyAdmin - Error You should upgrade to MySQL 5.5.0 or later
提问by user3400327
I installed phpMyAdmin-4.2.9.1-english on a Centos 6.5 platform.
我在 Centos 6.5 平台上安装了 phpMyAdmin-4.2.9.1-english。
2.6.32-431.23.3.el6.x86_64 #1 SMP Thu Jul 31 17:20:51 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
2.6.32-431.23.3.el6.x86_64 #1 SMP Thu Jul 31 17:20:51 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
When I login I get the following screen:
当我登录时，我看到以下屏幕：
phpMyAdmin - Error
You should upgrade to MySQL 5.5.0 or later.
I am using Server version: 5.1.73
我正在使用服务器版本：5.1.73
What should I do?
我该怎么办？
回答by Sérgio
I went to /usr/share/phpMyAdmin/libraries/common.inc.php and comment out this lines:
我去了 /usr/share/phpMyAdmin/libraries/common.inc.php 并注释掉这一行：
#if (PMA_MYSQL_INT_VERSION < 50500) {
# PMA_fatalError(
# __('You should upgrade to %s %s or later.'),
# array('MySQL', '5.5.0')
# );
#}
and now I can admin my mysql .
现在我可以管理我的 mysql 了。
UPDATE :
更新 ：
http://docs.phpmyadmin.net/en/latest/faq.html#faq1-17but doesn't explain why
http://docs.phpmyadmin.net/en/latest/faq.html#faq1-17但没有解释原因
why :
为什么 ：
https://sourceforge.net/p/phpmyadmin/bugs/4437/
https://sourceforge.net/p/phpmyadmin/bugs/4437/
https://github.com/phpmyadmin/phpmyadmin/commit/9112d7c9303b51b7e156cc98fa79ab8824b50e30
https://github.com/phpmyadmin/phpmyadmin/commit/9112d7c9303b51b7e156cc98fa79ab8824b50e30
回答by Isaac Bennetch
That particular version of phpMyAdmin is designed for more modern MySQL versions. To resolve the problem, you can either upgrade your MySQL installation or downgrade your phpMyAdmin. Upgrading your MySQL is probably going to involve upgrading to CentOS 7, so you probably aren't ready to do that. Fortunately, the phpMyAdmin team currently continues to support the 4.0.x branch, which requires only MySQL 5 or newer and PHP 5.2 or newer. So you can download 4.0.10.4 (or whatever the current 4.0.x release is) from http://www.phpmyadmin.net/home_page/downloads.php(where you can also see the listed requirements and anticipated end of life dates).
该特定版本的 phpMyAdmin 专为更现代的 MySQL 版本而设计。要解决此问题，您可以升级 MySQL 安装或降级 phpMyAdmin。升级你的 MySQL 可能会涉及升级到 CentOS 7，所以你可能还没有准备好这样做。幸运的是，phpMyAdmin 团队目前继续支持 4.0.x 分支，它只需要 MySQL 5 或更高版本和 PHP 5.2 或更高版本。因此，您可以从http://www.phpmyadmin.net/home_page/downloads.php下载 4.0.10.4（或任何当前的 4.0.x 版本）（您还可以在其中查看列出的要求和预期的生命周期结束日期） .
回答by Herbal
If you want to use PHPMyAdmin then recommend to upgrade your MySQL version to the latest [it is very important for security reasons]. For that, just follow few simple steps:
如果您想使用 PHPMyAdmin，那么建议将您的 MySQL 版本升级到最新版本 [出于安全原因，这非常重要]。为此，只需遵循几个简单的步骤：
. Export all your databases and take backup on your local system. - Upgrade your MySQL version to the latest one.. - Import all your database again from PHPMyAdmin panel.
. 导出所有数据库并在本地系统上进行备份。- 将您的 MySQL 版本升级到最新版本.. - 从 PHPMyAdmin 面板再次导入您的所有数据库。
Complete tutorials for export/import database from PHPMyAdmin...
You should not get much problem except password problem for already created database users. Just reset the password to fix it.
除了已经创建的数据库用户的密码问题外，您应该不会遇到太多问题。只需重置密码即可修复。
回答by a20
Use the instructions here to set up mysql repo and update your mysql to the latest version:
使用此处的说明设置 mysql 存储库并将您的 mysql 更新到最新版本：
http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/updating-yum-repo.html
http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/updating-yum-repo.html
It's better than hacking phpmyadmin down or using an old mysql version.
这比破解 phpmyadmin 或使用旧的 mysql 版本要好。
回答by Carlord
I did the upgrade, and everything goes to hell, I recommend to totally remove and do a clean mysql install from stratch in order to avoid headaches. Any way for a test environment you may use the hack answer commenting the lines in the "/usr/share/phpMyAdmin/libraries/common.inc.php" file or before install mysql, download and install the mysql-repo ad from there proceed to the PMA. Good luck.
我进行了升级，一切都变得糟糕，我建议完全删除并从 stratch 进行干净的 mysql 安装，以避免头痛。对于测试环境的任何方式，您都可以使用 hack answer 注释“/usr/share/phpMyAdmin/libraries/common.inc.php”文件中的行或在安装 mysql 之前，从那里下载并安装 mysql-repo 广告继续到 PMA。祝你好运。
回答by Prateek_N
Was getting this error only for one user on my cpanel hosting server.
仅针对我的 cpanel 托管服务器上的一位用户收到此错误。
I changed the max_questions: max_updates: max_connections: max_user_connections:values for the user facing the issue from "1" to "0"
我将max_questions: max_updates: max_connections: max_user_connections:面临问题的用户的值从"1" to "0"
Post this phpadmin started working.
发布此 phpadmin 开始工作。
回答by Webnet
You're using 5.1but you should be using > 5.5. You'll need to upgrade or use a different tool like MySql workbench
您正在使用，5.1但您应该使用> 5.5. 您需要升级或使用不同的工具，如MySql 工作台
