Need Help When Reset The Password To Pre-4.1 Style In Intallation

[applese]

first time install OSC2.2 in my Godaddy. get same problem "Client does not support authentication protocol requested

by server; consider upgrading MySQL client"

 

So follow the solution to Reset the password to pre-4.1 style in my computer.

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('myoldpassword')

-> WHERE Host = 'xx.xx.x.x' AND User = 'dbuser name';

Response I get: Query OK, 0 row affected (0.01 sec) Rows matched: 0 Changed: 0 Warnings: 0

 

It doesn't work for me. my problem is still there.

 

Where am I wrong? my system is 2000,mysql server5.0. The installation drives me crazy!

 

NEED HELP!