database connection error?

[jefferis]

Client site just went down with mysql errors:

Warning: mysqli::mysqli(): The server requested authentication method unknown to the client [mysql_old_password] in.../classes/db/mysqli.class.php on line 30

Warning: mysqli::mysqli(): (HY000/2054): The server requested authentication method unknown to the client in in...classes/db/mysqli.class.php on line 30

Fatal error: The server requested authentication method unknown to the client in in.../classes/db/mysqli.class.php on line 32

PHP Version 5.4.45, mysqlnd 5.0.10 , ionCube Loader

 

I can connect remotely to the DB with username and password and using PhpMysql on the Cpanel.     This issue happened without making changes on the server, host, php or mysql. 

 

Any ideas of cause  how to fix it?

TIA

[bsmither]

PHP hasn't been updated? The mysqlnd, if I am correct, is the PHP extension that talks to MySQL.

So, did the actual MySQL database server get updated?

You may need to get your hosting provider to work on this.

See:

https://www.cadence-labs.com/2017/08/wordpress-magento-mysql-php-fix-server-requested-authentication-method-unknown-client/
https://www.eschrade.com/page/the-server-requested-authentication-method-unknown-to-the-client-mysql_old_password/
https://serverfault.com/questions/295285/mysql-cannot-connect-via-localhost-only-127-0-0-1/297310#297310

 

[jefferis]

The mysql server version says:  5.6.41-84.1

However, while the phpinfo.php says we are running version 5x of php, the Cpanel is saying something different:

PHP version: 7.3.32

Edited February 8, 2022 by jefferis

[bsmither]

Perhaps an explanation from your hosting provider is in order.

If (when) your application gets to run under PHP 7, for all the plugins that use ionCube, they will need to be upgraded to run under an ionCube Loader built for PHP 7. Fortunately, you should be able to get that done easily.

Edited February 9, 2022 by bsmither