> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://krystal-dev.crisp.help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Reset a WordPress password using phpMyAdmin

Losing access to your WordPress site can be stressful. Particularly if it's a result of a site being hacked, however, don't panic!

This guide will show you how to update your WordPress user password using phpMyadmin.

||| Warning: You will be directly editing your database. If you aren't comfortable with this, we strongly recommend contacting your developer for assistance.

### Finding your database name:

Before we can edit the database, we will first need to find out which database we need to modify.

If you're only hosting a single website, you can skip this step, otherwise, follow the steps below:

1.  Log into cPanel
2.  Navigate to the "Domains" section and click on the "Domains" option

![](https://storage.crisp.chat/users/helpdesk/website/636f8be921c44800/23658e93-f3a4-42b2-b881-9b9a84_1sh1l2z.png)

1.  Find the domain name for your website and click the link to go to the document root for that site. In this case it will be public_html

![](https://storage.crisp.chat/users/helpdesk/website/e5b1484cba8fd000/fb631abe-bc71-4c11-aa9c-a0ad7e_fxc71r.png)

1.  Find the wp-config.php file

![](https://storage.crisp.chat/users/helpdesk/website/19e1f26e19e51000/b22a7fed-461c-47e4-abec-bea990_17gecmk.png)

1.  Right click on wp-config.php and select "Edit"

![](https://storage.crisp.chat/users/helpdesk/website/d3806fa9e75de80/e75f656a-ddab-4b17-b138-8aaff1_1eczuo0.png)

1.  You will recieve a warning, click "edit" to continue.

![](https://storage.crisp.chat/users/helpdesk/website/542e5a395cd5fc00/434e0870-b8d1-4579-ac5f-173e81_1ardw11.png)

1.  Look for the "DB_NAME" section, here you can find the name of your database. In this case it is "helpdocsiteskhos_7".

![](https://storage.crisp.chat/users/helpdesk/website/6872958c61f54800/73afe741-933d-4d16-8ff7-b7c6f3_1937vyn.png)

### Changing a password in phpMyAdmin:

Once you have your database name, follow the steps below to update the password.

1.  Login to cPanel
2.  Navigate to the "Databases" section and click "phpMyAdmin"

![](https://storage.crisp.chat/users/helpdesk/website/acfaf26a2931f000/de0c821f-b12a-4c99-853d-13a043_lc6ofo.png)

1.  On the left hand side you will see a list of databases, select your database to open a list of tables.

![](https://files.helpdocs.io/8nzbvyta9f/articles/t4k295y6e5/1683278800999/change-pass-myadmin-image-2.png)

1.  Search for the wp_users table

|| Note: The wp_ database prefix will be different depending on your cPanel username, however it will always end with _user.

![](https://files.helpdocs.io/8nzbvyta9f/articles/t4k295y6e5/1683278812795/change-pass-myadmin-image-3.png)

1.  You will now see a list of WordPress users. Find the email address relating to the user you wish to update the password for and click "Edit"

![](https://files.helpdocs.io/8nzbvyta9f/articles/t4k295y6e5/1683278825372/change-pass-myadmin-image-4.png)

1.  Find the "user_pass" section and enter your new password in the box in plain text.

![](https://files.helpdocs.io/8nzbvyta9f/articles/t4k295y6e5/1683278836820/change-pass-myadmin-image-5.png)

1.  Click on the blank "Function" dropdown next to the password and select "MD5".

![](https://files.helpdocs.io/8nzbvyta9f/articles/t4k295y6e5/1683278853139/change-pass-myadmin-image-6.png)

1.  Once you have entered the password and selected "MD5", click the "Go" option at the bottom of this screen.

![](https://files.helpdocs.io/8nzbvyta9f/articles/t4k295y6e5/1683278865948/change-pass-myadmin-image-7.png)

1.  Done!

You've now updated your wordpress password and you should be able to login to your wordpress dashboard as normal.

* * *

* * *