---
title: How to Reset a WordPress Password from phpMyAdmin
description: "**In short:** If you forgot your WordPress password: in cPanel open phpMyAdmin, choose your site's database, open the users table (wp_users or a table ending in _users), edit your user, type the new password in the user_pass field, choose MD5…"
url: "https://www.hyyat.com/en/knowledgebase/reset-wordpress-password-phpmyadmin/"
updated: "2026-09-29"
category: WordPress explanations
---

# How to Reset a WordPress Password from phpMyAdmin

**In short:** If you forgot your WordPress password: in cPanel open phpMyAdmin, choose your site's database, open the users table (wp_users or a table ending in _users), edit your user, type the new password in the user_pass field, choose MD5 in the Function column, and click Go.

![Reset a WordPress password from phpMyAdmin](https://hyyathost.com/images/2017/05/13/reset-wordpress-password.jpg)

## When do you need this?

Sometimes you cannot log in to WordPress, or you forgot the admin password and cannot recover it by email. In that case you can change the password directly in the database with phpMyAdmin, which comes with your hosting control panel.

## Steps

In this example we change the password of the user **admin**.

**1.** Log in to cPanel (yourdomain.com/cpanel) and click **phpMyAdmin** in the **Databases** section.

![phpMyAdmin in cPanel](https://hyyathost.com/images/2017/05/13/cpanel_phpmyadmin_block-ar.png)

**2.** phpMyAdmin opens in a new window and shows the databases in your account.

![Databases in phpMyAdmin](https://hyyathost.com/images/2017/05/13/cpanel_phpmyadmin_database_show-ar.png)

**3.** Click the database your WordPress site uses. If you are not sure which one, check DB_NAME in the site's **wp-config.php** file.

![WordPress database tables](https://hyyathost.com/images/2017/05/13/How-to-Reset-WordPress-Password-from-phpMyAdmin-Cpanel-Step-3.png)

**4.** Find the users table, usually named **wp_users** (the prefix may be different), and click **Search**.

![Search the users table](https://hyyathost.com/images/2017/05/13/cpanel_phpmyadmin_wordpress_database_search_users_user-ar.png)

**5.** In the **user_login** field, type the username (here: admin) and click **Go**. The matching user appears.

![Edit the WordPress user](https://hyyathost.com/images/2017/05/13/cpanel_phpmyadmin_wordpress_database_list_users_edit-ar.png)

**6.** Click **Edit** next to the user.

**7.** In the **user_pass** field, type the new password and select **MD5** from the **Function** drop-down. Do not save the password as plain text; without MD5 the new password will not work.

![Set user_pass with MD5](https://hyyathost.com/images/2017/05/13/cpanel_phpmyadmin_wordpress_save_user-ar.png)

**8.** Click **Go** to save.

You can now log in to WordPress with the new password. WordPress automatically converts it to a stronger hash on your first login. For extra safety, change the password again from your WordPress profile after logging in.

**Related service:** [Hyyat Host WordPress hosting](https://www.hyyat.com/en/wordpress-hosting/) is optimized for WordPress, from $1.93/month with free SSL and free migration.

 **Need this service from Hyyat Host?**Our team handles it for you, with support replying to tickets within 24 hours at most.[WordPress Hosting](https://www.hyyat.com/en/wordpress-hosting/)[WordPress design](https://www.hyyat.com/en/wordpress/)