lost password

Ok, I installed mySQL. Thanks to everyone that helped me, and I changed the
password for the root account, as suggested, but now I FORGET! How can I
get my password? Is it kept in a file somewhere? Do I need to
Uninstall/reinstall? I'd prefer not to. Please help.

Thanks All.

Re: lost password

Tony Peardon wrote:
> Ok, I installed mySQL. Thanks to everyone that helped me, and I changed the
> password for the root account, as suggested, but now I FORGET! How can I
> get my password? Is it kept in a file somewhere? Do I need to
> Uninstall/reinstall? I'd prefer not to. Please help.

For version 3.23, 4.0 and 4.1:
http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions .html

For 5.0:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions .html

For 5.1:
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions .html

You can pick any of them, they should be exactly the same.


//Aho