How to change password in MySQL?

[Tweaker]

Hi guys,
I am very much frustrated about changing the password to my MySQL account, so can anyone please tell me how to change a password for an existing user via mysqladmin? I have try out to many possibility but it all were worthless..
Please help me out.

[SreeKanth]

Hey Tweaker,

Following solution will definately solve your problem, and you will be feeling a sigh of relief.
just type the following command in the Dos prompt:
- mysqladmin - u root -p password "newpassword"

cheers

[Tweaker]

Thanks SreeKanth,
That command worked out, problem solved.