Error: Mysql connection

[Lassie]

I have just upgraded from mysql 4.0 to 4.1 and now get the following error message:
Could not connect to MySQL: Client does not support authentication protocol requested by server; consider upgrading MySQL client:
Can anyone shed light on this please.

[craygo]

You have to update your mysql password to use old style passwords. you have to do this thru the mysql command line

1. log in as root
2. mysql> use mysql
3. mysql> UPDATE user SET Password = OLD_PASSWORD('your_password_here') WHERE User = 'username_here' AND Host = 'hostname_here';
4. mysql>FLUSH PRIVILEGES;

Should be all set after that

Ray

[Lassie]

Thanks Ray