Menu
▾
▴
#1540 Add option to bypass MySQL version check
Right now, PMA always checks for the version of MySQL on the server you are connecting, not necessarily the server PMA is installed. In my case, I'm administrating a couple of servers, and one of them is on MySQL 5.0 (can change that unfortunately). But PMA itself is running on the latest Ubuntu version.
But since it checks the version of the server I'm connecting, I can't use the latest versions. It would be nice to have at least an option on the server list that would allow you to override the version check on common.inc.php .
Discussion
Well, we did not enforce this restriction for nothing: you will have problems retrieving some types of data from this older MySQL 5.0 server in a recent phpMyAdmin version.
I understand that possibility, that is why I thought about a config option, per server. So if an user wants, at their own risk, they could disable the check and go for it.
If you're talking about "Your PHP MySQL library version %s differs from your MySQL server version %s. This may cause unpredictable behavior.", there is already a configuration directive to disable this:
http://docs.phpmyadmin.net/en/latest/config.html?highlight=serverlibrarydifference_disablewarning#cfg_ServerLibraryDifference_DisableWarning
I'm talking about the "You should upgrade to MySQL 5.5.0 or later.", which is checked at line 996 on the common.inc.php file. In my setup I do have mysql 5.5 on the server that has the phpmyadmin tables, but one of the servers I need to admin is on 5.4 and can't be upgrade, and this check stops me.
It's correct to check the version to which phpMyAdmin is connecting. This verification was enforced in reaction to
https://sourceforge.net/p/phpmyadmin/bugs/4437/
and note that MySQL 5.5.0 was released 2009-12-07, so we really do not want to support older versions. Adding a configuration option to remove this message would potentially cause more harm.
Also note that phpMyAdmin 4.0.10.8 is still available for older MySQL versions. See the requirements listed at http://www.phpmyadmin.net/home_page/downloads.php for details.