How to reset WordPress admin/users password from Linux command line?

How to reset WordPress admin/users password from Linux command line?

We know how it can be done via PhpMyAdmin option in cPanel. We already discussed this in one of the previous post! Please check this link >> Reset WordPress users password – PhpMyAdmin << Did you get it? It’s simple.

We can change the WordPress users (Admin and other users) password in many ways.

1, From WordPress dashboard.

2, Via PhpMyAdmin in cPanel.

3, From MySQL command prompt.

The first option is simple. If you know
the current password go ahead and reset it from WordPress dashboard.
This can be done from profile section.

We already discussed the second option. Please see the above link.

Here we go with the third option.
Reseting WordPress users password from MySQL command prompt. It’s
simple. Please do follow the steps explained below:

1, Log into server as root.

2, Enter to MySQL command prompt.

[root@vps ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 265
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
mysql> 

3, Use WordPress database.

You can check the database name from the WordPress configuration file.

mysql> use user_images;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
~

4, Verify user details from “wp_users” table.

We need to select only the following details from “wp_users” table.

mysql> SELECT ID, user_login, user_pass FROM wp_users;
+----+------------+------------------------------------+
| ID | user_login | user_pass                          |
+----+------------+------------------------------------+
|  1 | admin      | $P$BjUKUieEYT1B3TnkQHsv4Y8hfnSK5t. |
+----+------------+------------------------------------+
1 row in set (0.00 sec)

mysql> 

This WordPress has only one user “Admin”. The password displayed here isn’t real, it’s in MD5 encrypted format.

5, Updating user password.

This is the point that we are looking
for. As I mentioned, the password displayed is in MD5 format. In latest
MySQL versions we can generate the password in MD5 format from the
commandline itself. Please see the syntax:

mysql> UPDATE wp_users SET user_pass = MD5(‘WPEXPLORER’) WHERE ID=1 LIMIT 1;

In previous versions we have to enter the password in MD5 format. It’s simple, we can generate it from here >> MD5 <<

Syntax to change the password

mysql> UPDATE wp_users SET user_pass = "61250b88abfe298f2df4821d081a3add"  WHERE ID=1;

Here the user pass in MD5 format.

See the updated password:

mysql> SELECT ID, user_login, user_pass FROM wp_users;
+----+------------+----------------------------------+
| ID | user_login | user_pass                        |
+----+------------+----------------------------------+
|  1 | admin      | 61250b88abfe298f2df4821d081a3add |
+----+------------+----------------------------------+
1 row in set (0.00 sec)

mysql> 

That’s it!! Now try to login with the new password.