Linux解决Warning: mysql_connect(): Headers and client library minor version mismatch. 警告

最新推荐文章于 2022-08-31 16:35:47 发布

m18994118189

最新推荐文章于 2022-08-31 16:35:47 发布

阅读量3.2k

点赞数 3

CC 4.0 BY-SA版权

分类专栏： mysql学习笔记文章标签： Linux解决Warning: mysql_connect(

本文链接：https://blog.youkuaiyun.com/m18994118189/article/details/83090933

mysql学习笔记专栏收录该内容

5 篇文章

订阅专栏

本文详细记录了解决Linux环境下因MySQL版本不匹配导致的警告信息的过程，通过卸载旧的php-mysql驱动并安装新的php-mysqlnd驱动，成功解决了headers and client library minor version mismatch的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Linux解决Warning: mysql_connect(): Headers and client library minor version mismatch. 警告

这两天用阿里云服务器重新部署网站服务器后，打开某php页面出现了如下警告：Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50547 Library:50631 in /XXX(某某目录)/wp-db.php on line 1520，虽然是警告，但是有的界面会因此打不开，甚是头疼，前不久用的是腾讯云服务器同样的部署方式并没有出现这个警告，一头雾水。

使用：

php -i|grep Client

查询当前Client 版本，结果如下：

Client API version => 5.6.31
Client API library version => 5.6.31
Client API header version => 5.5.47-MariaDB
Client API version => 5.6.31

好吧，header version => 5.5.47-MariaDB 出现个奇葩，版本号不一样，怪不得报错了。据某大牛说，版本不兼容，需升级MariaDB版本至少到5.6.31或许可以解决。我的系统是CentOS7.2版本，众所周知，CentOS从7.x系列版本开始抛弃了MySQL，缺省安装的是MariaDB，虽然MariaDB兼容MySQL，但是我还是比较喜欢MySQL，所以我给服务器强制安装了MySQL，也希望一直用下去，对于这个情况，升级MariaDB这条路是不能走了。考虑当前安装的是php-mysql驱动，而当前的php版本比较新，想到这个奇葩是不是因为驱动版本较低造成的，于是尝试以下操作：

[root@xiaobing html]# php -i|grep client
PHP Warning: Unknown: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in Unknown on line 0
MYSQL_LIBS => -L/usr/lib64/mysql -lmysqlclient
[root@xiaobing html]# php -i|grep Client
PHP Warning: Unknown: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in Unknown on line 0
Client API version => 5.6.41
Client API library version => 5.6.41
Client API header version => 5.5.56-MariaDB
Client API version => 5.6.41
[root@xiaobing html]# yum remove php-mysql
Loaded plugins: fastestmirror, langpacks
Resolving Dependencies
--> Running transaction check
---> Package php-mysql.x86_64 0:5.4.16-45.el7 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================================
Package Arch Version Repository Size
=========================================================================================================================================================
Removing:
php-mysql x86_64 5.4.16-45.el7 @os 232 k

Transaction Summary
=========================================================================================================================================================
Remove 1 Package

Installed size: 232 k
Is this ok [y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Erasing : php-mysql-5.4.16-45.el7.x86_64 1/1
Verifying : php-mysql-5.4.16-45.el7.x86_64 1/1

Removed:
php-mysql.x86_64 0:5.4.16-45.el7

Complete!
[root@xiaobing html]# yum install php-mysqlnd
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package php-mysqlnd.x86_64 0:5.4.16-45.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

Transaction Summary
=========================================================================================================================================================
Install 1 Package

Total download size: 174 k
Installed size: 462 k
Is this ok [y/d/N]: y
Downloading packages:
php-mysqlnd-5.4.16-45.el7.x86_64.rpm | 174 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : php-mysqlnd-5.4.16-45.el7.x86_64 1/1
Verifying : php-mysqlnd-5.4.16-45.el7.x86_64 1/1

Installed:
php-mysqlnd.x86_64 0:5.4.16-45.el7

Complete!
[root@xiaobing html]# systemctl restart httpd.service
[root@xiaobing html]# systemctl restart mysqld.service
[root@xiaobing html]# php -i|grep Client
PHP Warning: Unknown: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in Unknown on line 0
Client API version => mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Client API library version => mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Client API version => mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $

OK，版本全统一了，问题解决。