How to Reset WordPress Admin Password via phpMyAdmin

Knowledgebase / How to Reset WordPress Admin Password via...

How to Reset WordPress Admin Password via phpMyAdmin

0 found helpful (0 votes) ...
Back to Knowledgebase

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

  1. Log in to cPanel.
  2. Under Databases, click phpMyAdmin.

Step 2 — Find your WordPress database

  1. 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.
  2. Click on the wp_users table (the prefix may differ, e.g. mywp_users).

Step 3 — Edit the admin user

  1. Find the row for your admin account and click Edit.
  2. Find the user_pass field.
  3. In the Function dropdown next to user_pass, select MD5.
  4. In the Value field, type your new password.
  5. 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.


Was this article helpful?



Still need help?

Open a support ticket →

On This Page