How can I break into my own Drupal site?
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.