If you are WordPress blogger or webmaster, then chances are that you might face a situation where you would need to reset your administrator password. If you know your email address, then you could easily reset the password. But if for some reasons (hacking, deleted email account, etc.,) you can’t access your email, then you can’t reset your password easily. In such situations, you will change WordPress password using phpMyAdmin.
Let’s find out how you can change (reset) WordPress password using phpMyAdmin.
Change WordPress Password Easily Using phpMyAdmin:
1) To get started, log into your cPanel. To access your cPanel, enter any one of the following URL in your address bar:
yourdomain.com/cpanel or yourdomain.com:2082
Once you enter the above URL, you will be presented with your cPanel login screen. Enter your cPanel username and password and log into your web server control panel.
2) Once you have logged into cPanel, scroll down to “Databases” section. There you will see “phpMyAdmin” option. Click on it.
3) Now, you will see a page with the message “The system will redirect you in a moment“. Wait until you are redirected to phpMyAdmin database administration tool.
4) Once you are redirected to phpMyAdmin, you will see your database name along with some other settings as well. Just click on your database name to access its tables.
5) Now, you will see the list of tables under your WordPress website database. Click on “wp_users” table to access it rows.
6) Under “wp_users” table, there will be only one row if you have only one user. Click on “Edit” as shown in the picture below to change (reset) your WordPress password.
7) Now, you will see your WordPress username, WordPress password, WordPress administrator email, User registered time, etc. To edit your Password, go to “Value” column in the row “user_pass” and enter your new WordPress password. Once done, choose “md5” under “Function” column in the same row and then click on “Go”.
8) That’s it. Now you have successfully changed your WordPress password. You can follow the same procedure to change WordPress username and WordPress administrator email.
If you encounter any issues while following this tutorial, or if you have any queries regarding this tutorial, do let me know via comments.