On 22/01/17 20:03, Russell Coker via luv-main wrote:
http://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
As part of routine maintenance I upgraded MySQL to a more recent version on the LUV server. Unfortunately I didn't test the system properly and didn't notice that Drupal was down. The problem was that the Drupal database was so old that it had a less secure method of storing the password that is rejected by newer versions of MySQL.
Yikes! That is ancient. Glad you upgraded!
The solution was to just set the password again to the same value (I don't think that the localhost connections used for MySQL access were at risk of leaking the password - and if they were we have bigger problems than Drupal data).
Things should be fine now and the above URL is for anyone who is curious about the details or who is about to upgrade an old MySQL server.
Excellent, thanks for that. Cheers, Andrew