How to reset mysql root password?

[haans]

Hi,

Upon installation of mysql according to instruction I executed the following to set my root password for mysql
/usr/local/mysql/bin/mysqladmin -uroot password secret

where secret is the password.

How can I reset this password for user root since I can't reexecute again.

Thanks.

[bretticus]

http://www.mysql.com/doc/en/Resetting_permissions.html

[haans]

cheers mate.

At one stage, I almost wanted to give up my hope on learning php and mysql. I find it so frustrating and troublesome cus i am not a developer. I am new to the programming world. Now as time goes by, trial and error, with encouragement from you all who give hints/tips in this forum, i think i really have no reason not to continue it.

Thanks.