I lost my admin password! What to do?

 I lost my admin password, and am unable to retrieve via the 'lost password' email solution. What can I do?

Lost User#1 password

 This solution would work as long as you can access phpmyadmin on your host server. 
It basically involves creating a new user and copying and pasting that encrypted password into the User#1 password filed in the users table of your Drupal database.