How to reset admin password WordPress

Table of Contents

0.1 Introduction

1 How to reset admin password WordPress
2 Conclusion

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.

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.php

Conclusion

You have Reset admin password WordPress. I hope will this your helpful. Thank you for reading the DevopsRoles page!

DevopsRoles.com

Devops Tutorial

How to reset admin password WordPress

Introduction