This is an easy trick to reset your password without having to go through the email reset process which can be a bit shaky at times. Here’s how I do it via phpMyAdmin.

1. Select and edit the user row in question from the *_users table

2. Select MD5 from the Function dropdown in the user_pass row

3. Input a normal text password

4. Upon saving, you should see the new password hash