Hey, guys in this article, I will teach you how to get WordPress username and password from database.
You forgot your WordPress login password? Can’t reset password manually? there is another way to reset user & Admin passwords directly in your WordPress database using phpMyAdmin.
Everyone knows WordPress is a very popular platform for blogging but if we forget this password so we don’t how to recover it.
So I suggest if you want to reset your WordPress username and password so complete read this article and properly understand how to get WordPress username and password from database.
Here we will learn how to easily reset WordPress passwords from phpMyAdmin.
Why Get WordPress Username and Password From Database
Actually, if the password is lost or forgotten, it is very easy to recover the lost password. Simply go to the login screen of your WordPress website and click on the ‘Forgot your password?’ link…
When you click on the link, you will be taken to a password reset page. After entering your username or email address, WordPress will send a password reset link to the associated email address.
You won’t be able to reset the password if you don’t have access to that email address or if your WordPress website fails to send an email.
In such conditions, then to reset the WordPress password you have to go directly to the database.
The easiest way to do this is to use phpMyAdmin.
Having said that, let’s see how to reset the WordPress password from phpMyAdmin. If you want to secure your blog/website so read this article on how to secure website from hackers in PHP.
How to Get WordPress Username and Password From Database
First, please log in to the cPanel dashboard of your WordPress hosting account. Next, select the Database menu where you can click on the phpMyAdmin icon.
The phpMyAdmin application will appear, then select the database from your WordPress website.
You will see a list of tables in your WordPress database. Find the table with the name wp_users (according to the table prefix name) in this list and click the Browse link next to it.
Note: The table names in your WordPress database may have different prefixes than those shown in this layer. The table prefix name will be different according to your website’s table_prefix setting.
You will now see a row in the WordPress users table. To change a password, go ahead and click the edit button next to the username you wish to change it for.
PhpMyAdmin will display a form with fields containing WordPress user information.
Please delete the value in the user_pass column and replace it with your new password. Under the capacity field, select MD5 starting from the drop menu and afterward click the Go button at the lower part of the structure.
Your password will be encrypted using an MD5 hash and then will be stored in the database.
Safe! You have successfully changed your WordPress password using phpMyAdmin.
You may ask why to choose MD5 hashes to encrypt passwords. WordPress previously used MD5 hashes to encrypt passwords, but since WordPress 2.5 it has used stronger encryption technologies.
However, WordPress still recognizes MD5 to provide legacy compatibility. WordPress will convert your password to the latest encryption algorithm as soon as you generate one that is stored as an MD5 hash.
Hope this tutorial helped you learn how to get WordPress username and password from database. So if you like our article so comment below and share your opinion with our team.