Sorry about coming into this thread late.
You should read this page:
http://www.mysql.com/doc/en/Password_hashing.html
It details how to upgrade your user tables to MySQL 4.1.x and still
allow old clients to connect to the server.
On Wed, 03 Sep 2003 19:50:37 +1000, Vinoaj Vijeyakumaar spoke
one way it to use old_password ()instead of password(), when creating
new user name, or update the password for those existing user names with
the old_password() function.
but then this will force you to use the old password() function, which
doesn't really help much...
Vinoaj Vijeyakumaar
On 03 September 2003 10:51, Vinoaj Vijeyakumaar contributed these pearls of
wisdom:
Hi,
Just this morning I upgraded to MySQL 4.1.0 alpha and PHP
4.3.3. I'm also
running Apache 2 on a WinXP machine. The main reason for the
upgrade was so that I could make use of 4.1.0's sub-select