Reset Drupal Password, the SQL Way

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.