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.
I’ll take a Coppermine database as example, but it works the same for WordPress.

First of all we must login to our PHPMyAdmin of course and from there we move to the users tab and edit on the user we wanna change password for

From there in user_password you type your new password and from the dropdown select MD5.
user_password_salt is a sort of cookie of your password so we must delete whatever is written in there and leave blank (please note: it’s not always present and/or something written)

Save and your new password will work to login.