18

I installed phpMyAdmin-4.2.9.1-english on a Centos 6.5 platform.

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

What should I do?

War10ck
  • 12,387
  • 7
  • 41
  • 54
user3400327
  • 181
  • 1
  • 2
  • 3
  • 2
    No offense, but the solution would appear to be pretty cut and dry. Upgrade your MySQL version or don't use PHPMyAdmin. I'm sure you could use a different tool or possibly find an older version of PHPMyAdmin to run as well. Maybe a download mirror hosts an old version somewhere... – War10ck Oct 06 '14 at 18:35

7 Answers7

39

I went to /usr/share/phpMyAdmin/libraries/common.inc.php and comment out this lines: 

    #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 .

UPDATE :

http://docs.phpmyadmin.net/en/latest/faq.html#faq1-17 but doesn't explain why

why :

https://sourceforge.net/p/phpmyadmin/bugs/4437/

https://github.com/phpmyadmin/phpmyadmin/commit/9112d7c9303b51b7e156cc98fa79ab8824b50e30

Sérgio
  • 6,966
  • 1
  • 48
  • 53
  • 6
    Hi .. appreciate this simple tip, but does anyone know why pma blocked mysql < 5.5? Any incompatibilities or security problems? – a20 Dec 03 '14 at 04:59
  • 3
    This may work, but if the version is blocked it's not "just because ". This is a sloppy solution. – dsnunez Jan 08 '15 at 15:40
8

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).

Isaac Bennetch
  • 11,830
  • 2
  • 32
  • 43
1

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:

. 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.

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.

Herbal
  • 217
  • 2
  • 10
0

Use the instructions here to set up mysql repo and update your mysql to the latest version:

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.

a20
  • 5,495
  • 2
  • 30
  • 27
0

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.

Carlord
  • 1
0

Was getting this error only for one user on my cpanel hosting server.

I changed the max_questions: max_updates: max_connections: max_user_connections: values for the user facing the issue from "1" to "0"

Post this phpadmin started working.

Kurt Van den Branden
  • 11,995
  • 10
  • 76
  • 85
Prateek_N
  • 3
  • 1
-5

You're using 5.1 but you should be using > 5.5. You'll need to upgrade or use a different tool like MySql workbench

Ben
  • 60,438
  • 111
  • 314
  • 488