{"id":364,"date":"2010-08-13T06:05:18","date_gmt":"2010-08-13T12:05:18","guid":{"rendered":"http:\/\/blog.supportpro.com\/2010\/08\/how-to-reset-wordpress-admin-password-from-phpmyadmin\/"},"modified":"2025-08-20T06:26:51","modified_gmt":"2025-08-20T12:26:51","slug":"how-to-reset-wordpress-admin-password-from-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/how-to-reset-wordpress-admin-password-from-phpmyadmin\/","title":{"rendered":"How to reset Wordpress Admin password from phpMyadmin"},"content":{"rendered":"

If you\u2019ve forgotten your WordPress admin password, don\u2019t worry\u2014you can easily reset it through your cPanel using phpMyAdmin<\/strong>.<\/p>\n

Steps are as follows:<\/p>\n

1. Log in to cPanel<\/strong><\/p>\n

2. Navigate to phpMyAdmin<\/strong><\/p>\n

3. Click the database associated with your WordPress installation.<\/p>\n

<\/p>\n

4. Look out for wp_users<\/strong> and access this table.<\/p>\n

5. Now this will show the fields inside the wp_users<\/strong> table<\/p>\n

6. Look out for the “admin<\/strong>” under the user_login.<\/strong><\/p>\n

7. Remember its corresponding ID<\/strong>, just in case if we need to confirm it later.<\/p>\n

8. Click Edit<\/strong> on the same field<\/p>\n

9. Check out for user_pass<\/strong> field<\/p>\n

10. Delete the list of letters and numbers (it’s an encrypted format)<\/p>\n

11. Enter your desired password (normal password), example: wppasswd (it’s case sensitive)<\/p>\n

12. After that, click the drop-down next to user_pass<\/strong> ie, varchar(64), and select MD5<\/p>\n

13. Click Go <\/strong>to save the changes<\/p>\n

14. You are done! Now check if the new password is working.<\/p>\n

Conclusion<\/h3>\n

Resetting your WordPress admin password through phpMyAdmin is a quick and reliable method, especially if you don\u2019t 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<\/p>\n

If you require help, contact SupportPRO Server Admin<\/a><\/p>\n

\"Server<\/a><\/span>