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 :
Find out your wp_user table.
Find out user_pass column, then locate the ID for which you want to reset password.
Delete the existing password.
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.