If you cannot log in to WordPress and cannot receive the password reset email, you can reset your password directly in the database using phpMyAdmin in cPanel.
Step 1 — Open phpMyAdmin
- Log in to cPanel.
- Under Databases, click phpMyAdmin.
Step 2 — Find your WordPress database
- In the left sidebar, click on your WordPress database name. If you are unsure which database WordPress uses, check the DB_NAME value in your wp-config.php file.
- Click on the wp_users table (the prefix may differ, e.g. mywp_users).
Step 3 — Edit the admin user
- Find the row for your admin account and click Edit.
- Find the user_pass field.
- In the Function dropdown next to user_pass, select MD5.
- In the Value field, type your new password.
- Click Go to save.
Step 4 — Log in to WordPress
Go to https://yourdomain.com/wp-admin and log in with your username and the new password you just set.
Important: After logging in, go to Users → Profile and update your password there as well. This ensures WordPress hashes the password in its own secure format.