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
[php]
wp_set_password( ‘yourpassword’, 1 );
[/php]

Option 1:

[php]
update_user_meta(1, ‘user_pass’, ‘yourpassword’);
[/php]

Option 2:
[php]
wp_update_user( array (‘ID’ => 1, ‘user_pass’ => ‘yourpassword’) ) ;

[/php]
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.