mysql 5.0 which I used
I want to connect to it when it say the user&password is wrong

I use the follow way to make it

mysql>update mysql.user set password=OldPassword("newpwd")

->where host='yourhost' and user='youruser';

share it!