Resetting WordPress Account Password from Database

So, after months of hibernating my WordPress project, I forgot the "admin" password and lost the file where I stored my credential.

The solution - update the entry in the database!  Sour yet sweet!

UPDATE 'wp_users' SET 'user_pass'= MD5('<password>') WHERE 'user_login'='<username>';

Be sure to commit the change.