Saturday, February 24, 2007

Client does not support authentication ..

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.

UPDATE mysql.user
SET password=OLD_PASSWORD('somepassword')
WHERE user='someuser'
AND host='somehost';

After you have set the passwords to the old format, flush the tables.

flush privileges;

1 comment:

Samuel said...

Works nicely, Thanks for that.

-Samuel