What really causes PHP MySQL library version differs from your MySQL server version?

Question

This message appears in PhpMyAdmin. Often after some update.

There are already a lot of similar questions. One typical answer is "update your libs". But in the end I still see a lot of people who can't solve it. (myself included)

I've tried to reinstall everything from scratch but it's still there and I get this exact version error:

Your PHP MySQL library version 5.5.34 differs from your MySQL server version 5.1.69.

I've added the output of my packages list. Everything looks correct. Or so I think. I don't understand where this 5.1.69 version comes from. I don't have much knowledge of linux / server setup.

Is there any linux/server wizard who can help? thank you : )

[root@server bin]# yum list installed | grep mysql

@remi compat-mysql51.x86_64 5.1.54-1.el6.remi
@remi mysql.x86_64 5.5.34-1.el6.remi
@remi mysql-libs.x86_64 5.5.34-1.el6.remi
@remi mysql-server.x86_64 5.5.34-1.el6.remi
@remi php-mysql.x86_64 5.4.20-1.el6.remi

[root@server bin]# yum list installed | grep php

@remi php.x86_64 5.4.20-1.el6.remi
@remi php-bcmath.x86_64 5.4.20-1.el6.remi
@remi php-cli.x86_64 5.4.20-1.el6.remi
@remi php-common.x86_64 5.4.20-1.el6.remi
@remi php-fpm.x86_64 5.4.20-1.el6.remi
@remi php-gd.x86_64 5.4.20-1.el6.remi
@remi php-imap.x86_64 5.4.20-1.el6.remi
@remi php-ldap.x86_64 5.4.20-1.el6.remi
@remi php-magickwand.x86_64 1.0.9.2-4.el6.remi
@remi php-magpierss.noarch 0.72-6.el6
@epel php-mbstring.x86_64 5.4.20-1.el6.remi
@remi php-mcrypt.x86_64 5.4.20-1.el6.remi
@remi php-mssql.x86_64 5.4.20-1.el6.remi
@remi php-mysql.x86_64 5.4.20-1.el6.remi
@remi php-odbc.x86_64 5.4.20-1.el6.remi
@remi php-pdo.x86_64 5.4.20-1.el6.remi
@remi php-pear.noarch 1:1.9.4-12.el6.remi.1
@remi php-php-gettext.noarch 1.0.11-4.el6.remi
@remi php-recode.x86_64 5.4.20-1.el6.remi
@remi php-shout.x86_64 0.9.2-9.el6.remi
@remi php-snmp.x86_64 5.4.20-1.el6.remi
@remi php-soap.x86_64 5.4.20-1.el6.remi
@remi php-tcpdf.noarch 6.0.031-1.el6.remi
@remi php-tcpdf-dejavu-sans-fonts.noarch 6.0.031-1.el6.remi
@remi php-tidy.x86_64 5.4.20-1.el6.remi
@remi php-xml.x86_64 5.4.20-1.el6.remi
@remi php-xmlrpc.x86_64 5.4.20-1.el6.remi
@remi phpMyAdmin.noarch 4.0.6-1.el6.remi

The configuration I'm running is CentOs 6.4 nginx/1.4.2 Database client version: libmysql - 5.5.34 PHP extension: mysqli Localhost via UNIX socket

Answer 1

Your php-mysql package has been linked against an older MySQL client library. It's strongly suggested to install php-mysqlnd, see http://www.webtatic.com/packages/php54/. Then restart your web server.