mysql_connect(): 标头和客户端库次要版本不匹配 库:100005


mysql_connect(): Headers and client library minor version mismatch Library:100005

自从上周五执行常规软件包更新以来,我的网络服务器遇到了一个相当棘手的问题。我在使用 mysql_connect() 时遇到错误。

Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50532 Library:100005 in /srv/www/***/wp-includes/wp-db.php on line 1142

当我运行php -i时,我得到:

mysqli
MysqlI Support => enabled
Client API library version => 10.0.5-MariaDB  
Client API header version => 5.5.32

apt-get install mariadb*

导致已安装以下软件包:

libmariadbclient18 is already the newest version.
libmariadbclient18 set to manually installed.
mariadb-client is already the newest version.
mariadb-client-10.0 is already the newest version.
mariadb-client-10.0 set to manually installed.
mariadb-client-core-10.0 is already the newest version.
mariadb-client-core-10.0 set to manually installed.
mariadb-common is already the newest version.
mariadb-common set to manually installed.
mariadb-server is already the newest version.
mariadb-server-10.0 is already the newest version.
mariadb-server-10.0 set to manually installed.
mariadb-server-core-10.0 is already the newest version.
mariadb-server-core-10.0 set to manually installed.

我已经在网上查找了这个问题,但似乎没有一个类似的问题在库版本中带有 -MariaDB 标签。

所以我不知道如何解决这个问题。

非常感谢您的帮助!

编辑:

PHP -i MySQL:

MySQL Support => enabled
Client API version => 10.0.5-MariaDB

奇怪的是,没有提到客户端 API 库版本或本部分中的客户端 API 标头版本。

为 PHP

启用 mysqlnd、nd_mysqlnd_mysqli 扩展,如果启用了 mysql 和 mysqli,则禁用它们(PHP 5.5)。

响应较晚,但这在搜索结果中很高,这是对我有用的解决方案,因为没有人对服务器具有管理员访问权限。

安装 PHP 的 mysqlnd 包,警告应该会消失。

对于基于 Debian/Ubuntu 的系统,这将是:

sudo apt install php-mysqlnd

sudo apt install php7.0-mysqlnd

安装后重新启动服务器守护进程(apache、nginx 和/或 php-fpm)