# How to reset the WordPress administrator password via phpMyAdmin

Access phpMyAdmin from the Kiravo control panel and open the `wp_users` table. Identify your admin user and click **Edit**. Next to the `user_pass` field, select the **MD5** function, enter your new password in the text column, and click **Go**. You can now log in to WordPress with your new password.

## In-depth tutorial

Losing access to your WordPress dashboard is inconvenient, but solvable. If the email recovery function is unavailable, changing the password directly in the database is the reliable solution. You can do this quickly through phpMyAdmin.

Modifying the database requires care. Follow these steps to regain access to your site safely.

### Access phpMyAdmin from the Kiravo Control Panel

Access phpMyAdmin from your [hosting control panel](https://webhostingpanel.eu/login).

Our tutorial for [accessing phpMyAdmin](https://kiravo.net/access-phpmyadmin/) provides all necessary steps.

### Identify the Users Table

On the left side, select the database corresponding to your WordPress site.

![phpMyAdmin interface](https://kiravo.net/wp-content/uploads/2026/02/phpmyadmin-interface-1.webp)Look for the table named `wp_users`. If you changed the table prefix during installation, it might have a different name, such as `example_users`. Click on the table name to see the list of all registered users on the website.

![users phpMyAdmin](https://kiravo.net/wp-content/uploads/2026/02/users-wp-phpmyadmin.webp)### Edit the Administrator Profile

Find the row corresponding to your administrator account and click the **Edit** button.

![edit user administrator](https://kiravo.net/wp-content/uploads/2026/02/edit-user-administrator-1.webp)You will see a list of all information fields for your profile. Identify the row named `user_pass`.

![row user_pass in phpMyAdmin](https://kiravo.net/wp-content/uploads/2026/02/row-user-pass-phpmyadmin.webp)### Configure the New Secure Password

In the Function column, choose the **MD5** option from the dropdown menu. This function is essential because it encrypts the password so WordPress can recognize it. In the **Value** column, delete the existing text and type your new password.

![write new password in the value field in phpmyadmin](https://kiravo.net/wp-content/uploads/2026/02/write-new-password-here-value-phpmyadmin.webp)Scroll to the bottom of the page and click the **Go** button.

![button Go in phpMyAdmin](https://kiravo.net/wp-content/uploads/2026/02/button-go-phpmyadmin.webp)### Verify Site Access

Return to your WordPress login page. Enter your username and the newly set password. Your access is now restored. We recommend using a complex password to maintain account security.

If you need assistance, please [contact](https://kiravo.net/contact/) the Kiravo support team.