MySQLdb and MySQL 4.1 server :(

[Gabriel Cooper]

JZ wrote:

>MySQLdb 1.0 cannot connect to MySQL 4.1 server when the user has non-empty
>password :(
>
>_mysql_exceptions.OperationalError: (1251, 'Client does not support
>authentication protocol requested by server; consider upgrading MySQL
>client')
>  
>
MySQL changed the way they do the PASSWORD() function. try resetting 
your mysql users' passwords using OLD_PASSWORD() instead and it will 
start working again. I just had this problem two days ago and found the 
answer in a simple web search for the error... *(cough)"

Gabriel.