Skip to main content

GoDaddy Help

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/ Managed WordPress).

    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 login with your new password.

Related steps

More info

Community Related

psionw's Avatar
Change Wordpress MySQL database password

1 Replies

Last posted almost 3 years ago.

Ovidiu's Avatar
WP install error - Access denied for user

1 Replies

Last posted over 3 years ago.

pjakarim's Avatar
Need help changing managed wordpress phpmyadmin password

4 Replies

Last posted over 3 years ago.

royh962's Avatar
connect to mysql not working

1 Replies

Last posted over 3 years ago.

Don't see what you are looking for? Search the Community