MySQL older versions(<<5.x)

1.You will have to generate an MD5 hash of your desired password. You can generate one from here

2. Get access to MySQL command prompt.

Enter the mysql root password.

3. Get the list of databases currently on your server.

4. Select your wordpress database ( here it is foryou_wp)

5. Find the table name with ‘users’ at the end ( here it is wp_users)

6. To get the details about the user, user ID etc; enter the following command.

7. Update the new password with the following command.

Command should look like:

8. Make sure that the password has changed.

9. Quit from mysql prompt.

MySQL recent versions (5.x)

Skip step 1 and replace the step 7 with following.

Command should look like:

That’s it!