背景
部署php項(xiàng)目溜族，查看httpd的error.log時(shí)發(fā)現(xiàn)有如下報(bào)錯(cuò)：
[Fri Sep 25 09:39:36.906590 2020] [:error] [pid 12835] [client 192.168.235.20:52444] PHP Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50564 Library:50645 in /var/www/html/v4/lib/qeephp/library/db/adapter/mysql.php on line 66, referer: https://pro4.aishu.cn/v4/public/index.php?namespace=user&controller=accountsubsidy
意思很好理解讹俊，就是數(shù)據(jù)庫(kù)版本和客戶端版本不匹配，我使用的是MySQL5.7.29煌抒，php-mysql安裝的是5.4.16-48.el7仍劈。
解決辦法
卸載php-mysql：
[root@node-23 logs]# yum remove php-mysql -y
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package php-mysql.x86_64 0:5.4.16-48.el7 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================================================
Removing:
php-mysql x86_64 5.4.16-48.el7 @base 232 k
Transaction Summary
=============================================================================================================================================================================================
Remove 1 Package
Installed size: 232 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Erasing : php-mysql-5.4.16-48.el7.x86_64 1/1
Verifying : php-mysql-5.4.16-48.el7.x86_64 1/1
Removed:
php-mysql.x86_64 0:5.4.16-48.el7
Complete!
安裝高版本的php-mysqlnd：
[root@node-23 logs]# yum install php-mysqlnd -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
base | 2.3 kB 00:00:00
extras | 1.5 kB 00:00:00
updates | 1.5 kB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package php-mysqlnd.x86_64 0:5.4.16-48.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================================================
Installing:
php-mysqlnd x86_64 5.4.16-48.el7 base 174 k
Transaction Summary
=============================================================================================================================================================================================
Install 1 Package
Total download size: 174 k
Installed size: 461 k
Downloading packages:
php-mysqlnd-5.4.16-48.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-48.el7.x86_64 1/1
Verifying : php-mysqlnd-5.4.16-48.el7.x86_64 1/1
Installed:
php-mysqlnd.x86_64 0:5.4.16-48.el7
Complete!
重啟httpd服務(wù)：
[root@node-23 logs]# systemctl restart httpd.service
歡迎訪問(wèn)我的個(gè)人博客：Lemon - 萬(wàn)事順?biāo)?/a>
