IUS Community Project

phpMyAdmin MySQL Version Mismatch

Asked by Infin1ty

I've installed php53 and mysql 51 as shown in the manuals, but when i log into phpmyadmin i keep getting this: "Your PHP MySQL library version 5.0.89 differs from your MySQL server version 5.1.42. This may cause unpredictable behavior."
What could cause it? it seems as php53-mysql was not compiled with the correct mysql libraries?

Thanks.

Question information

Language:
English Edit question
Status:
Answered
For:
IUS Community Project Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
BJ Dierkes (derks) said : 		#1

Hello... sorry for the delay in my response. This is a common concern, which can be a bit unclear when explaining.

php53 is built against stock MySQL 5.0 (libmysqlclient15). However, since you've upgraded to mysql51 the system requires mysqlcleint15 to be installed to provide the libraries for all applications built against mysql-5.0. Currently our mysqlclient15 packages are version 5.0.89 so that is version of the libmysqlclient15 library that php53-mysql is using. In order for php53-mysql to match to installed version of mysql51 (libmysqlclient16) php53 would need to be rebuilt 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

Unfortunately this is not something we have done at this time. That said, I can tell you that in the last 4 years of providing packages in this 'mixed' kind of fashion... I'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.

Can you help with this problem?

Provide an answer of your own, or ask Infin1ty for more information if necessary.

To post a message you must log in.