Hi John,
Resetting your password is quite easy if you have some knowledge about cpanel and database. Below are the steps to reset/change your password directly from database.
If you have hosting with cpanel, you can do the following steps:
1) Login to Cpanel
2) Search for phpmyadmin on cpanel home page after login.
3) select the database connected with you wordpress website
4) search for table wp_users (wp_ is the prefix of tables, that you selected when you initially setup your website and may differ)
5) from wp_users table, search for your username and click on edit user
6) from edit user screen, type in new password in password field and select MD5 from dropdown.
you can follow steps in the below page which shows all steps with proper screenshots:
If you have any difficulty with it, please contact me and I will be happy to help you with this.
Resetting Your Password
goto option “Through phpMyAdmin” on the above page.
Thanks
Vikas
This doc:
Resetting Your Password
Has about 7 different ways to reset your password, all of them work. You just need to find one that matches your access and abilities.