Just thought I would post a solution (temporary at best, but a solution at
least.) for all those using PostNuke who have upgraded MySql to 4.1. I have
had problems with PostNuke logging into MySql after upgrading to MySql 4.1.
I received the message:
"Client does not support authentication protocol requested by server.
Consider upgrading MySQL client."
After reading here:
http://www.mysql.com/doc/en/Old_client.html
And here:
http://www.mysql.com/doc/en/Password_hashing.html
* I simply edited my startup script for MySql Server on my box to launch
with:
mysqld_safe --old-passwords
* Restarted my MySQL server
* and then changed my MySQL passwords with the OLD_PASSWORD function rather
than the previous PASSWORD function.
It solved my problem. I was able to create a new site database and all was
well! Hope that helps! :)
Matt