Home / server / Questions / 228532
Accepted
NARKOZ
Asked: 2011-01-30 07:37:10 +0800 CST

MySQL: Headers and client library minor version mismatch

  • 772

I have this error when I try to connect to database using PHP:
mysql_connect(): Headers and client library minor version mismatch. Headers:50147 Library:50501

And this warning in phpmyadmin:
Your PHP MySQL library version 5.5.1-m2 differs from your MySQL server version 5.1.54. This may cause unpredictable behavior.

Packages installed:

Percona-Server-client-51-5.1.54-rel12.5.188.rhel5.x86_64
Percona-SQL-shared-compat-5.1.43-2.x86_64
Percona-Server-server-51-5.1.54-rel12.5.188.rhel5.x86_64
percona-release-0.0-1.x86_64

PHP version:PHP 5.3.3
MySQL: mysql Ver 14.14 Distrib 5.1.54
OS: Amazon AMI 64bit

I tried to remove php and install again, but no success.

mysql php percona

2 Answers

  1. Best Answer

    Changed type of database connection in vbulletin config from mysql to mysqli and problem solved.

    • 3

  2. Looks like your SQL shared compat libraries are a version behind the client and the server, as the error message states this can result in some funny behaviour.

    Try upgrading the package Percona-SQL-shared-compat-5.1.43-2.x86_64 to Percona-SQL-shared-compat-5.1.54-2-rel12.5.188.rhel5.x86_64, it should be available from the same package repo where you upgraded the rest of your installation from.

    • 1