phpmyadmin @4.2.3_0+php54 produces error message about needing MySQL5.5.0 or later after login

[roberthuston@…]

After doing a port upgrade to phpmyadmin @4.2.3_0+php54, when I log into my phpMyAdmin page, I am directed to a page posting a bold red banner containing a "phpMyAdmin-Error" message, with a line below it stating "You should upgrade to MySQL 5.5.0 or later." The previous version of phpMyAdmin did not exhibit this behavior, and the phpMyAdmin project page indicates that this version should still work with my installation of MySQL (v5.1.x).

I currently have the following pertinent ports installed and running:

  apache2 @2.2.27_0+preforkmpm (active)

  php54 @5.4.29_0+libedit (active)
  php54-apache2handler @5.4.29_0 (active)
  php54-gd @5.4.29_0 (active)
  php54-iconv @5.4.29_0 (active)
  php54-mbstring @5.4.29_0 (active)
  php54-mcrypt @5.4.29_0 (active)
  php54-mysql @5.4.29_0+mysqlnd (active)
  php54-zip @5.4.29_0 (active)

  mysql5 @5.1.72_0 (active)
  mysql5-server @5.1.72_0 (active)

My config.inc.php file is very simple:

<?php

// use a value of your choice
$cfg['blowfish_secret'] = '0123456789abcdef';

$i=0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';

?>

[roberthuston@…]

I forgot to also mention that my MediaWiki and concrete5 installations are working correctly, so the MySQL server is indeed running correctly and my access to it is still operational.

Lastly, reverting to phpmyadmin@4.2.2_0+php54 makes everything work again.

[ryandesign (Ryan Carsten Schmidt)]

I agree, phpmyadmin 4.2.3 did add an error message to upgrade to MySQL 5.5.0. If you believe that error message shouldn't have been added, or that the phpmyadmin documentation is out of date, you should report those problems to the developers of phpmyadmin. All MacPorts does is package the code they provide.

[roberthuston@…]

OK, thank you. You may want to consider updating your MAMP info on the "howto" page with the MySQL 5.5.* specification.

This may be out of place here, but can I upgrade my MySQL installation in place, or do I need to dump the tables, uninstall, install new, and then re-import. (I think I already know the answer but maybe there's a better way.)

Thanks again. You can close the ticket if you want.

[roberthuston@…]

I think I found my answer ... gotta do it the hard way. Oh well.

​http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html

[ryandesign (Ryan Carsten Schmidt)]

Yes, you should follow the upgrade instructions. Another option might be to switch to mariadb or even percona at this point.

[josephaw@…]

Cc Me!