Reset password in wordpress from database directly
There are a lot of tables in any wordpress installation, in order to reset user password password we have follow some simple steps as :
Step 1
Find out your wp_user table.
Step 2
Find out user_pass column, then locate the ID for which you want to reset password.
Step 3
Delete the existing password.
Step 4
Type your new password in any file (say notepad). Convert MD5 of this string from any web sites and then after computing MD5 paste the string here (user_pass) and you are done.