PHP libmysqlclient_18 error in mysqli.so with the PHP 5.4 on Plesk

Issue

The "php -v" command provide the "warning" message:

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysqli.so' - /usr/lib64/php/modules/mysqli.so: symbol client_errors, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference in Unknown on line 0

# php -v
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysqli.so' - /usr/lib64/php/modules/mysqli.so: symbol client_errors, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference in Unknown on line 0
PHP 5.4.16 (cli) (built: Apr 14 2020 10:39:35)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v10.0.3, Copyright (c) 2002-2017, by ionCube Ltd.

Environment

• CloudLinux 7
• CloudLinux 8
• Plesk

Solution

To solve the problem remove the current "php-mysql" package from your system:

# rpm -e --nodeps `rpm -qa | grep -v "alt-" | grep "php-mysql-"`

Install "php-mysqlnd" package:

# yum install php-mysqlnd