How to change WordPress admin password using PHPMyAdmin

How to gain back the WP admin access using phpMyAdmin or any other MySQL admin tool at your disposal