Building User Accounts and PHPMyAdmin

[Dustin Rabe]

I have upgraded my MySQL Server to 4.1 and have had better luck with some of the features with MySQL Administrator. however now when I login with PHPMyAdmin it errors out telling me to upgrade my client, error below.

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

I read in a forum for me to add this line to my my.ini file, and restart my server.

#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

This seems incomplete. Is this correct? Where in the my.ini file do I put this? If I use this will I have to still do the following?

I have to go to the command line to MySQL Server and type the following command to get my passwords to work through the PHPMyAdmin interface:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Does anyone know how to make MySQL 4.1.9 use pre 4.1 password hashing?

Thanks,

xydon