Reset WordPress password from the command line

You can use the below steps to change the WordPress login :

1. Login to the mysql :

mysql -u root -p;

2. Select the database :

use database_name;

3. List the Users :

select * from wp_users\G

Note : Note down the password before you change. Just in case your client want the same password :p

4. Change the password for the user you required :

UPDATE wp_users SET user_pass=MD5('new_password') where ID=id_you_need;

Enjoy !!! 🙂 🙂 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s