mysql

update users set pass=md5('NEWPASS') where uid = 1;

I constantly find myself needing to google up a page like this to figure out how to reset a password without troubling the website.

Here’s my own little note.

Resetting the mysql root password shouldn’t have to happen. But every time it does, I go insane. This page is a set of notes detailing methods that have proven to work.