GoDaddy Help

Change my WordPress password in the database

Follow the steps below to update a WordPress password through the database. This is helpful if you can't receive the password reset email.

  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 _users table.
    select users table
  3. Next to the user you want to update, select Edit.
    select edit
  4. In the Value column, delete the contents of the user_pass box.
    delete old password
  5. Enter your new password into the same box.
    enter new password
  6. In the function column, use the drop-down menu and select MD5.
    select md5
  7. Select Go.

You can now sign in with your new password.

Related steps

More info