Change/reset WordPress password in the database PHPMyAdmin

This method involves editing and updating the wp_users table values to reset our lost WordPress password. The method is little longer but is also easy enough to follow without a lot of technical knowledge.

1. Connect to your host and access PHPMyAdmin
2. Click on your WordPress database (_wpXXXXXX)
3. Navigate to and click the table wp_users
4. Edit the row with your WordPress username
5. Now, in the user_pass field, change the function to MD5 and enter your new password in the Value section
6. Click “Go” or similar option at the bottom to update the table values

Source: http://wpcrux.com/change-wordpress-password-phpmyadmin/