Jump to content

database connection error?


jefferis
 Share

Recommended Posts

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

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

 

  • Like 1
Link to comment
Share on other sites

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 by jefferis
Link to comment
Share on other sites

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 by bsmither
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...