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.