Home Miscellaneous How to reset WordPress Admin password from phpMyadmin

How to reset WordPress Admin password from phpMyadmin

by SupportPRO Admin

If you’ve forgotten your WordPress admin password, don’t worry—you can easily reset it through your cPanel using phpMyAdmin.

Steps are as follows:

1. Log in to cPanel

2. Navigate to phpMyAdmin

3. Click the database associated with your WordPress installation.

4. Look out for wp_users and access this table.

5. Now this will show the fields inside the wp_users table

6. Look out for the “admin” under the user_login.

7. Remember its corresponding ID, just in case if we need to confirm it later.

8. Click Edit on the same field

9. Check out for user_pass field

10. Delete the list of letters and numbers (it’s an encrypted format)

11. Enter your desired password (normal password), example: wppasswd (it’s case sensitive)

12. After that, click the drop-down next to user_pass ie, varchar(64), and select MD5

13. Click Go to save the changes

14. You are done! Now check if the new password is working.

Conclusion

Resetting your WordPress admin password through phpMyAdmin is a quick and reliable method, especially if you don’t have access to the WordPress dashboard. By following the steps above, you can securely regain access to your website within minutes. Always remember to choose a strong password and update it reg

If you require help, contact SupportPRO Server Admin

Server not running properly? Get A FREE Server Checkup By Expert Server Admins - $125 Value

Leave a Comment