phpMyAdmin PHP/MySQL Version Mismatch

Created by BJ Dierkes
Keywords:

Under certain scenarios, phpMyAdmin may display the following warning:

"Your PHP MySQL library version X.Y.z differs from your MySQL server version A.B.c."

This is a common concern, which can be a bit unclear when explaining. Please note that in the future, the following information may not be accurate (OS/MySQL versions, etc) but the answer should still be relevant.

The IUS php5x (or similar) packages are built against stock MySQL 5.0 on RHEL 5. However, since when upgrading to mysql51 (or similar) the system requires mysqlcleint15 to be installed to provide the libraries for all applications built against mysql-5.0 (The stock version of MySQL on RHEL). The version that php5x-mysql displays for the "MySQL Library Version" is related to the version of mysqlclient15 installed. In order for php5x-mysql to match the installed version of mysql51 (libmysqlclient16) php5x would need to be rebuilt on the system with mysql51 installed.

We have considered providing alternatives like so:

 - php52-mysql (stock mysql)
 - php52-mysql50 (mysql50.ius)
 - php52-mysql51 (mysql51.ius)

 - php53-mysql (stock mysql)
 - php53-mysql50 (mysql50.ius)
 - php53-mysql51 (mysql51.ius

In fact, we have 'php53-pgsql84' built and in testing at this time which is a 'trial' for doing the same with php5x-mysql. Unfortunately this is not something we have done at this time, but hope to soon (submissions are welcome). That said, I can tell you that in the last 4+ years of providing packages in this 'mixed' kind of fashion... we've never really come across any major issues of using php built against an older version of mysql... talking to a new version of mysql.