Headers and client library minor version mismatch

Question

In PHP I m getting the following warning whenever I try to connect to a database  via mysql connect      Warning  mysql connect    Headers and client library minor version mismatch  Headers 50162 Library 50524   In my php -i output I have the following values listed under mysqli     Client API library version    5 5 24      Client API header version    5 1 62   I ve tried updating php5-mysql and php but I m already at the latest version of both of them  How do I go about updating the header version so I stop seeing this warning   EDIT  My MySQL files should all be updated to be the latest version     apt-get install mysql  5 5       mysql-client-5 5 is already the newest version  mysql-server-core-5 5 is already the newest version  mysql-server-5 5 is already the newest version  mysql-testsuite-5 5 is already the newest version  mysql-source-5 5 is already the newest version    Removing old versions    apt-get remove mysql  5 1       Package handlersocket-mysql-5 1 is not installed  so not removed Package mysql-cluster-client-5 1 is not installed  so not removed Package mysql-cluster-server-5 1 is not installed  so not removed Package mysql-client-5 1 is not installed  so not removed Package mysql-client-core-5 1 is not installed  so not removed Package mysql-server-5 1 is not installed  so not removed Package mysql-server-core-5 1 is not installed  so not removed Package mysql-source-5 1 is not installed  so not removed

User · Answer

For new MySQL 5 6 family you need to install php5-mysqlnd  not php5-mysql   Remove this version of the mysql driver  sudo apt-get remove php5-mysql   And install this instead  sudo apt-get install php5-mysqlnd

User · Answer

Changing PHP version from 5 6 to 5 5 Fixed it    You have to go to control panel   CGI Script and change PHP version there

User · Answer

I am using MariaDB and have the similar problem   From MariaDB site  it is recommended to fix it by   Switch to using the mysqlnd driver in PHP  Recommended solution   Run with a lower error reporting level    err level   error reporting 0      conn   mysql connect  params      error reporting  err level     Recompile PHP with the MariaDB client libraries  Use your original MySQL client library with the MariaDB    My problem fixed by using the mysqlnd driver in Ubuntu   sudo apt-get install php5-mysqlnd   Cheers      update  extra information  Installing this driver also resolve PDO problem that returns integer value as a string  To keep the type as integer  after installing mysqlInd  do this   db   new PDO  mysql host    host   dbname    db name   user   pass             array  PDO  ATTR PERSISTENT   gt  true     db- gt setAttribute PDO  ATTR EMULATE PREPARES  false    db- gt setAttribute PDO  ATTR STRINGIFY FETCHES  false

User · Answer

If u had access cpanel or whm for domain web hosting      In cPanel  Go to  Softwares and services  tab     and then click  Select PHP Version     set your desired version of php       Eg  Current PHP version    PHP Version  5 2    list of 5 2  5 3  5 4  5 5  5 6 available php versions   Warning  Changing php modules and php options via PHP Selector for native php version is impossible  I selected 5 6 php version  after that error cleared on my wordpress blog site

User · Answer

I ran into the same issue on centos7  Removing php-mysql and installing php-mysqlnd fixed the problem  Thanks Carlos Buenosvinos Zamora for your suggestion    Here are my commands on centos7 just in case this can be of help to anybody as most of the answers here are based on Debian Ubuntu   To find the installed php-mysql package  yum list installed   grep mysql   To remove the installed php-mysql package  yum remove php55w-mysql x86 64   To install php-mysqlnd  yum install php-mysqlnd x86 64

User · Answer

My hosting company told me to fix this by deactivating  quot mysqli quot  and activating  quot nd mysqli quot  in the php extensions  The error is gone  but I don t have the knowledge to understand if this is the right method to fix this

User · Answer

For WHM and cPanel  some versions need to explicty set mysqli to build   Using WHM  under CENTOS 6 9 xen pv  dc   v68 0 27  one needed to rebuild Apache PHP by looking at all options and select mysqli to build  The default was to build the deprecated mysql  Now the depreciation messages are gone and one is ready for future MySQL upgrades

User · Answer

I have this problems when use Percona MySQL 5 6 and the php driver was compiled with 5 5 and php5-mysql is required for some apps  so I write a script to rebuild the drivers   https   github com falcacibar php5-mysql-rebuild

User · Answer

Your PHP was compiled with MySQL 5 1 but now it is linking a mysql library of 5 5 X family  You have to upgrade PHP to a version compiled with MySQL 5 5 or revert back mysql client libraries to 5 1 x

User · Answer

I got same php warring in my wordpress site         Err  Warning  mysql connect    Headers and client library minor version mismatch  Headers 50547 Library 50628 in  home lhu public html innovacarrentalschennai com wp-includes wp-db php on line 1515   Cause  I updated wp 4 2 to 4 5 version  PHP and MySql mismatch    I changed wp-db php on line 1515   this- gt dbh   mysql connect   this- gt dbhost   this- gt dbuser   this- gt dbpassword   new link   client flags      to   if   WP DEBUG          this- gt dbh   mysql connect   this- gt dbhost   this- gt dbuser   this- gt dbpassword   new link   client flags      else        this- gt dbh    mysql connect   this- gt dbhost   this- gt dbuser   this- gt dbpassword   new link   client flags        Its got without warring err on my wordpress site

User · Answer

Warning  mysqli  mysqli    Headers and client library minor version mismatch  Headers 50547 Library 100026   I solved the above error by just rebuilding my Apache   cPanel Version  56 0  build 25  Apache Version  2 4 18 PHP Version 5 5 30 MySQL Version   10 0 26-MariaDB

User · Answer

To compile php from source with MySQL native driver  mysqlnd    cd  php source path   configure  lt other-options gt  --with-mysql --with-mysqli --with-pdo-mysql make clean      required if there was a previous make  which could cause various errors during make make make install   From  php source path configure --help     --with-mysql DIR        Include MySQL support   DIR is the MySQL base                       directory  if no DIR is passed or the value is                       mysqlnd the MySQL native driver will be used --with-mysqli FILE      Include MySQLi support   FILE is the path                       to mysql config   If no value or mysqlnd is passed                       as FILE  the MySQL native driver will be used --with-pdo-mysql DIR    PDO  MySQL support  DIR is the MySQL base directory                       If no value or mysqlnd is passed as DIR  the                       MySQL native driver will be used   One or more PHP MySQL extensions can be included by using these options  If a value is not passed to these options  or if the value is mysqlnd  MySQL native driver will be used

User · Answer

The same works for MySQL   sudo apt-get install php5-mysqlnd   I ve read this thread trying to find the solution for MySQL  and I ve also seen ken s answer  but I ignored the solution for MariaDB  wasting a few hours that way  It wasn t clear for me that the same may apply to MySQL  This post is just to spare you the few hours I lost

User · Answer

The root reason for this error is that PHP separated itself from the MySQL Client libraries some time ago  So what s happening  mainly on older compiles of linux  is that people will compile PHP against a given build of the MySQL Client  meaning the version of MySQL installed is irrelevant  and not upgrade  in CentOS this package is listed as mysqlclientXX  where XX represents the package number   This also allows the package maintainer to support lower versions of MySQL  It s a messy way to do it  but it was the only way given how PHP and MySQL use different licensing   MySQLND solves the problem by using PHP s own native driver  the ND   which no longer relies on MySQL Client  It s also compiled for the version of PHP you re using  This is a better solution all around  if for no other reason that MySQLND is made to have PHP talk to MySQL   If you can t install MySQLND you can actually safely ignore this error for the most part  It s just more of an FYI notice than anything  It just sounds scary

[php] Headers and client library minor version mismatch

Examples related to php

Examples related to ubuntu

Examples related to mysqli

Examples related to warnings