Cannot reset main admin password

Unable to recover the main admin password as the email is not sending (or not being received) not in SPAM/Junk etc.

I have access to MySQL and can see the username and hashed PW etc. Also have full accesses etc to site, just not the admin pw.

Is there a reset outside of the 'reset' via email on the login page. This is frustrating...

Drew, no worries, all sorted found old threat with the hash for password. All sorted and password is reset ...

Thank you...