Unable to connect to MySQL database - mysql_old_password

Avatar
  • Answered
Without any change on the PHP files or MySQL database on our site, we are now seeing the following error message:
([directory] has been substituted for the actual directory for security reasons)

Warning: mysql_connect(): The server requested authentication method unknown to the client [mysql_old_password] in /home/[directory]/public_html/check_security_top.php on line 4

Warning: mysql_connect(): The server requested authentication method unknown to the client in /home/[directory]/public_html/check_security_top.php on line 4
Could not connect

Please advise if changes were recently made to MySQL or PHP configuration by inMotion.
Avatar
JeffMa
This is caused by the MySQL user using an old style of passwords with a smaller hash and is thus less secure. To resolve the issue, simply try removing the old MySQL user and re-creating it using the same username and password. At that time, your issue should then be resolved.