To reset the admin password via database:
- add this snippet to index.php after drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
- go to page, copy password
- revert changes in index.php
- go to database and paste password in user table