Having some fun with TurboGears. Trying out it's Python 2.3 support. Got the following error, Client does not support authentication protocol requested by server; consider upgrading MySQL client. I should be using at least Python 2.4, but doing work on an older server that only has Python 2.3 support. Not an optimal fix, but I found this one when searching on the topic.
Client does not support authentication
Login to mysql as an administrator, then, paste the following command, editing as necessary, to change the password of the user to the old format.
After you have set the passwords to the old format, flush the tables.