How can I break into my own Drupal site? I was doing a Media module tutorial. Half way through it I decided to install the tutorial companion files and foolishly replaced my files. In the companions readme it says the admin login is username - admin and password - admin. 

But it is not! Now i’m completely locked out. Can someone tell me how I might break in to my tutorial site? I have access to the DB via PHPMyAdmin.

I was thinking a MySQL update command to the password field for the admin. Can someone tell me what I could use to reset the admin password?

I changed the admin email address then requested a new password but it has not fired off an email. 
I believe the password encryption method is sha1().
If you're using Linux:


Install drush if you haven't already
Go to /install_directory/sites/mysite
Type sudo drush uli
Copy the link to your browser


Drush is extremely useful for many things.  The above will log you in as user 1, after which you can reset your password in the usual way.