Far too often now we forget the passwords to access, or our browsers delete caches and cookies and we cannot reset from the scripts.
Fear not, because PHPMyAdmin comes to the rescue.

First of all we must login to our PHPMyAdmin of course and from there we move to the users tab (in my case called wp_users) and edit on the user we wanna change password for

From there in user_pass you type your new password and from the dropdown select MD5.

Save and your new password will work to login.