Owners of WordPress sites usually remember and keep their admin passwords saved. But unfortunately, sometimes it can get lost.
Forgetting the admin password of your WordPress site is a hassle for sure. But it’s not that hard to recover the WordPress admin password from the database.
Ways to recover WordPress Admin Password
There are a couple of ways to recover your WordPress site’s admin password. The easiest way is to go to the wp-admin login page and press on forget the password. But when you forget your User Id and Password both, then it’s difficult to recover your admin credentials from there.
Accessing the database of your WordPress site is the best way to get the admin name and password without remembering any of them. All you have to do is follow the steps described below.
Get WordPress Admin Password from Database within 3 Simple Steps
The main goal to recover your admin password will start from the phpMyAdmin dashboard. But you must access it via other platforms like cPanel or localhost dashboard.
Step 1: Get access to phpMyAdmin
Navigate to the cPanel login page and access your cPanel account.
After successfully logging in cPanel dashboard, search for PHP. You will find the icon and the name of phpMyAdmin in the database sector.
Now click on it to open your phpMyAdmin login page.
There is another way to access phpMyAdmin via a local host. But to make it happen first check that your computer is configured with a local host setup. Now open your local host dashboard.
The interface of the local host may look different but the basic functionality will remain the same. Look for the phpMyAdmin clickable switch or icon. Hit the button to directly go to your PHP login page.
Step 2: Log in to phpMyAdmin Dashboard and find your WP site
When the MyAdmin login page of PHP gets loaded in your browser’s screen, enter the user name and password. Then press the Go button to enter your dashboard.
In the phpMyAdmin panel, there will be expandable options in the left menu. Find your WordPress site there and click on it.
If you have multiple websites then click on the right one. Make sure you entered in the desired website by checking the database name from the top bar of the screen.
Step 3: Search your Admin Name & Password and modify them
Now, search for wp_users from the search bar. Click on the wp_user link to open the page with all existing users’ names and passwords.
In this way, you will be able to get a WordPress admin password from the database. But still, if you wish to modify the password or change admin access then click on the edit button and a new window will open from where you will be able to change them.
Below you can see the admin user name and password changeable options. If you need to edit or modify them then just type and save them before leaving the page.
A Tip for the New WordPress Site Owners
Losing or forgetting your WordPress admin username or password can be threatening as per security issues. So try to keep them written into a safe vault online or write them down on paper and keep it somewhere safe.
The steps described above can help you to find a proper answer on how to get WordPress admin password from database. But still, you have to remember a few credentials related to cPanel and phpAdmin. Without any kind of credentials, it will be impossible to dig down and find the admin password.
So try to save all the important credentials somewhere safe and run your WordPress site smoothly. if you have any questions in your mind related to this topic communicate with us for help.