Table of Contents
How to reset WordPress admin/users password from Linux command line?
Ans:
* Log into server as root.
* Enter to MySQL command prompt.
root@grand [~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 932677 Server version: 5.5.42-cll MySQL Community Server (GPL) Copyright (c) 2000, 2015, 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.
* 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 ~
* 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.
* 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.
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.
