HowtoForge: Setting and Changing MySQL Root Password

Great article on HowtoForge on dealing with how to recover from forgetting MySQL's root password (which I admit I did a few years back on a server I had set up years before even that). Having this article back then would have saved me a lot of searching.