Client does not support authentication protocol MYSQL

[ME]

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