jefferis Posted February 8, 2022 Share Posted February 8, 2022 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 Link to comment Share on other sites More sharing options...
bsmither Posted February 8, 2022 Share Posted February 8, 2022 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 Link to comment Share on other sites More sharing options...
jefferis Posted February 8, 2022 Author Share Posted February 8, 2022 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 Link to comment Share on other sites More sharing options...
bsmither Posted February 9, 2022 Share Posted February 9, 2022 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.