Reset WordPress Password Using MySQL Command Prompt

What is WordPress?

WordPress is a leading blogging tool, period. It is free and open source software. The latest stable release of Wordpress is version 3.8 .
Download it :- http://wordpress.org/download/

Now, I will show, How to reset WordPress password using MySQL command prompt.
Prerequisites:
1. Name of the database being used by the WordPress installation.
2. MySQL server address. (IP or Hostname)
3. MySQL login details of 'root' user.
4. The user ID of the user whose associated password you want to change.

                                              Logging in to MySQL Command Prompt

For WINDOWS,
In the case of offline installation (Host = localhost) of WordPress in Windows using WAMP/XAMPP, then to launch the MySQL CMD, click on the WAMP icon > MySQL > MySQL console. If you did not set any password before, then password is blank by default, means you don't need to enter any password, just press 'Enter' .

WAMP Download :- http://www.wampserver.com/en/
XAMPP Download :- http://www.apachefriends.org/en/xampp.html

For LINUX,
In the case of offline installation (Host = localhost) of WordPress in Linux using LAMP, then just launch terminal emulator & type the command :-   mysql -u root -p

If you want to reset the password in remote server, then simply connect it via SSH using any SSH client.
Example: PuTTY (Download :- http://www.putty.org/ )
PuTTY is a SSH and telnet client. It is a open source software.
After logging in to remote server, to login to MySQL, type the following command :-
mysql -u root -p <password>

                                            Resetting the WordPress Password 

Let,
1. WordPress database name : wp_db (in my case)
2. User ID : 1
3. New Password will be : HACKTREE

                                                          -: wp_db looks like :- 

Ok, so lets start. Enter the following commands :-

use wp_db;
SELECT ID, user_login, user_pass FROM wp_users;
UPDATE wp_users SET user_pass = MD5('HACKTREE'); 

(The MD5 message-digest algorithm is a widely used cryptographic hash function that produces a 128-bit hash value.)

To exit MySQL CMD, type the command : exit

Thank you.