From time to time you may encounter an unusual situation wherein you need to reset your WordPress password but you no longer have access to the email address associated with your account.
Here’s a quick MySQL snippet that will change your password
# Reset Password UPDATE wp_users SET user_pass = MD5( 'new_password' ) WHERE user_login = 'your-username';
Instructions for use:
1. Replace the new_password with your new password.
2. Replace your-username with your username.
3. Fire up phpMyAdmin and go to your database.
Open the SQL tab.
Paste the above snippet into the text field and click on the Go button.
You should now be able to log in to your WordPress site using your new password.