Unable to connect to MySQL database - mysql_old_password

Avatar
username
  • 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.
Replies 1
Avatar
0
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.