Its essential thing to knowing, how to reset the wordpress password from Mysql server without following traditional method. Because your site may hacked, you may forgot your admin password and its email id to reset the password, you are no longer able to login into wordpress using login credentials. This method will very useful to reset your password.
Follow the below steps to reset your wordpress password from Mysql server:
Step1: Select your database from the Mysql Server.
Step 2: Select the *_users table from your selected database.
Step 3: In that table, edit the user which you want to reset the password.
Step 4: Due to security reasons, WordPress stores the passwords as MD5 Hash rather than Plain text. The password was stored in the user_pass field value.
Step 5: Generate your password with MD5 hash method and update the field value of the respective user in that table.
Now, You have successfully changed your wordpress password.