Change my WordPress password in the database

by

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

image-26
  1. Sign in to phpMyAdmin. Note: If you’re using cPanel Hosting, you must select the database for your WordPress site in the left-hand column before continuing to the next step.
  2. From the sidebar menu, select the wp_users table.
    image-22
  3. Next to the user you want to update, select Edit.
    image-23
  4. In the Value column, delete the contents of the user_pass box.
    image-24
  5. Enter your new password into the same box.
    image-25
  6. In the function column, use the drop-down menu and select MD5.
    image-26
  7. Select Go.

You can now sign in with your new password.

More info