[plug] Python mysqld + mysql5.0

[Simon Marko]

Shayne O'Neill wrote:

>Hey,
>I've written a fairly intensive script to do a bunch of stuff in python
>-> a mysql server
>
>Its developed to a usual mysql4.0 server and it all works honky dory.
>
>HOWEVER
>
>When I point it at the production server, which is mysql5.0 (huzzah for
>flash over stability) 
>It crashes out with this;-
>
>"Client does not support Authentication protocol requested by the
>server; consider upgrading MySQL client."
>
>So.... I upgraded dev db + clientlibs to mysql5.0 out of the dotdeb
>archives and yeah.
>
>:( Still no dice.
>
>Anyone know where I might fix this? I'm pretty baffled
>
>Shayne
>Bestflights
>  
>
Hi Shayne - From MySQL 4.1, a new password-hashing algorithm was used 
which the 4.0 client does not understand.
Take a look at http://mysql.com/doc/refman/5.0/en/old-client.html for a 
couple of solutions, one of them should help.

Best of Luck
::SimonM::


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.7/409 - Release Date: 4/08/2006