How to reset the password of user 1

If you forget the password or otherwise need to gain access to the Drupal administrative user account (user/1), you can run the following SQL on the database:

UPDATE `users` SET `pass` = MD5('mynewpassword') WHERE `uid` =1 LIMIT 1;

where mynewpassword is the new password you'd like to use.