Change your WordPress password in the database

You can update a WordPress password through the database. This is helpful if you can't receive the password reset email.

  1. Log into phpMyAdmin (cPanel / Plesk / Web Hosting / Managed WordPress).

    Note: If you're using cPanel Hosting, you must select the database for your WordPress site in the left-hand column before proceeding to the next step.

  2. Click on the _users table.
  3. Click Edit next to the user you want to update.
  4. In the Value column, delete the contents of the user_pass box.
  5. Type your new password into the same box.
  6. In the function column, use the drop-down menu and select MD5.
  7. Click Go

You can now login with your new password

More Info