If you’ve forgotten your WordPress Username and Password, all hope isn’t lost because I’ll help you get it back from your database in your hosting CPanel.
Every single user and data collected on your WordPress Website is stored in a database on your hosting account, from the database, you can view the name, email, and password of every user on your site including the admin.
For other hosting platforms, this process may be a bit harder due to bots creating a lot of spam accounts and the database hosting being super slow, that’s why I recommend Hostinger.
With Hostinger, you can purchase WordPress Hosting for just $2.99 per month, then move your site by performing a backup and restoring it on your new hosting.
How do you get your WordPress Username and Password from the Database?
To get your WordPress Username and Password from your database, you need to access the database by logging in to your hosting account and then CPanel > PHPMYADMIN, then click on your WordPress Database name (usually wp-xxx).
All tables in your WordPress Database will be loaded on the main interface and the table that houses your WordPress Username and Password is wp-users, click on it.
Once you’ve clicked on wp-users, you’ll get a list of all user accounts on your site, this should just be only you if bots don’t attack your site and you don’t collect memberships and signups.
If You find that there are a lot of users on your site and they don’t even comment on your site plus their emails are temporary Email addresses, delete their accounts and learn how to fix Bot Traffic on your Website.
The database will now pull out your details, you only need a user login and user pass to sign into your website again.
Login to Hosting CPANEL account, then click on PHPMYADMIN, click on your site’s database in the left navigation menu, then search for your username or password in the wp-users table.
To recover your WordPress password without Email, you’ll have to head over to PHPMYADMIN in your Hosting CPANEL account, then make sure you’re on the right database, search for your WordPress username in the wp-users table and you should see your password.
I hope you were successful in recovering your WordPress Username, Password, and Email from your Database as easily as I’ve written in this article.
This resource is helpful if you’ve forgotten or misplaced your password or if some hacker used a nulled WordPress Theme or Plugin to break into your WordPress site and change your admin password so you can’t log in.
I persuade all my readers to always purchase their WordPress Themes and Plugins from Themeforest to avoid these types of issues.
If you have any questions on How to get WordPress Username and Password from Database Easily, feel free to tell me in the comments.