Here’s how to update password with having access in phpmyadmin and you forgot the email use in your admin account.
Solutions:
Add to your functions.php
wp_set_password( 'yourpassword', 1 );
Option 1:
update_user_meta(1, 'user_pass', 'yourpassword');
Option 2:
wp_update_user( array ('ID' => 1, 'user_pass' => 'yourpassword') ) ;
Where 1 is the admin User ID and ‘yourpassword’ is your password, do not use md5.
Access your site and you can now access your dashboard using your username and new password.