Knowledgebase

If you cannot reset your WordPress password via email (because your email is not working or the reset email is not arriving), you can reset it directly in the database using phpMyAdmin.

Step-by-Step: Reset WordPress Password in phpMyAdmin

1. Log in to cPanel.
2. Click phpMyAdmin in the Databases section.
3. In the left panel, find and click your WordPress database. It is usually named something like cpanelusername_wordpress or cpanelusername_wrdp.
4. Click on the wp_users table (note: the prefix wp_ may be different if your WordPress uses a custom prefix).
5. You will see a list of users. Find your admin user and click the Edit button (pencil icon) on that row.
6. Find the user_pass field.
7. In the Function dropdown for user_pass, select MD5.
8. In the Value field (next to user_pass), type your new password. Keep it simple for now — you can change it to a stronger one after logging in.
9. Scroll down and click Go to save.
10. Go to yourdomain.com/wp-admin and log in with the username and the new password you set.
11. Once logged in, go to Users > Your Profile and update your password to a stronger one.

Important: WordPress actually stores passwords using a more secure hashing method than plain MD5. When you save a new password via phpMyAdmin using the MD5 function, WordPress will automatically upgrade the hash to its secure format the next time you log in. This is normal and expected.

Note: Not sure which database is your WordPress database? In cPanel File Manager, open public_html/wp-config.php and look for the line define('DB_NAME', 'database_name_here'); — that is your database name.