Table of Contents
Introduction
In this tutorial, I lost the admin password WordPress. How to reset admin password WordPress. Did you forget your WordPress admin password? Don’t worry; it happens to the best of us. Thankfully, resetting your admin password is a straightforward process.
How to reset admin password WordPress
You’ve logged into the MySQL database server as the root user and you’re trying to access the wordpressdb database. Here are the steps you’ve taken, For Example, I will use wordpressdb database.
[root@server1 ~]# mysql -u root -p
mysql> show databases;
mysql> use wordpressdb;The output is below
[root@server1 ~]# mysql -u root -p
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| wordpressdb |
+--------------------+
5 rows in set (0.01 sec)
mysql> use wordpressdb;
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
mysql> Find the user table
mysql> show tables;The output is as below:
mysql> show tables;
+-----------------------+
| Tables_in_wordpressdb |
+-----------------------+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_termmeta |
| wp_terms |
| wp_usermeta |
| wp_users |
+-----------------------+
12 rows in set (0.00 sec)Find users
mysql> SELECT ID, user_login, user_pass FROM wp_users;The output is below
mysql> SELECT ID, user_login, user_pass FROM wp_users;
+----+------------+------------------------------------+
| ID | user_login | user_pass |
+----+------------+------------------------------------+
| 1 | admin | $P$B3jZNLbpdkZBm9NkkgtnfyaT7ECXWl0 |
+----+------------+------------------------------------+
1 row in set (0.00 sec)The administrator is usually user number 1
mysql> SELECT * FROM wp_users where id = '1';The output is as below:
mysql> SELECT * FROM wp_users where id = '1';
+----+------------+------------------------------------+---------------+--------------------+------------------------+---------------------+---------------------+-------------+--------------+
| ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name |
+----+------------+------------------------------------+---------------+--------------------+------------------------+---------------------+---------------------+-------------+--------------+
| 1 | admin | $P$B3jZNrepdkZBm9NkkgtnfyaT7ECXWl0 | admin | pvhuu285@gmail.com | http://192.168.122.229 | 2020-09-04 04:11:59 | | 0 | admin |
+----+------------+------------------------------------+---------------+--------------------+------------------------+---------------------+---------------------+-------------+--------------+
1 row in set (0.00 sec)For MySQL 5 and higher
just execute a query like this to reset the password for the admin WordPress
mysql> UPDATE wp_users SET user_pass = MD5 ('123456789') WHERE ID = '1';Check again
mysql> SELECT * FROM wp_users where id = '1';The output is as below:
mysql> SELECT * FROM wp_users where id = '1';
+----+------------+------------------------------------+---------------+--------------------+------------------------+---------------------+---------------------+-------------+--------------+
| ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name |
+----+------------+------------------------------------+---------------+--------------------+------------------------+---------------------+---------------------+-------------+--------------+
| 1 | admin | $P$BaDO1CjqaJhGcYKwsk0va7dlAj5cXp. | admin | pvhuu285@gmail.com | http://192.168.122.229 | 2020-09-04 04:11:59 | | 0 | admin |
+----+------------+------------------------------------+---------------+--------------------+------------------------+---------------------+---------------------+-------------+--------------+
1 row in set (0.00 sec)We log in through wp-login.php and input a new password, as usual.
http://192.168.122.229/wp-login.phpConclusion
You have Reset admin password WordPress. I hope will this your helpful. Thank you for reading the DevopsRoles page!
