WNYpress

Change my WordPress password in the database

Note: View WNYPress Managed Hosting for WordPress plans. Follow the steps below to update a WordPress password through the database. This is helpful if you can’t receive the password reset email. 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…

Note: View WNYPress Managed Hosting for WordPress plans.

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 step

More info

Still need help?

If this article didn’t solve the problem, send WNYpress the details and we’ll help you with the next step.