Connect with us

Hi, what are you looking for?


Update WordPress User Password from phpMyAdmin

In the scenario where an admin forgets their password or is locked out and needs to change the password it can be done through phpMyAdmin.

Open phpMyAdmin through Cpanel or other methods depending on the hosting setup and find the WordPress database. Click on the WordPress database and a table called mainusers should be found. Click on that table name to open it and see the list of users in the table.

Click Edit next to the user that needs the password changed and it should look similar to the image below.

phpMyAdmin before update
Before Updating Password

On this page choose MD5 from the Function dropdown menu and enter in the new password into the Value text field. At the bottom of the page click Go.

phpMyAdmin after update
Prior to submitting new password

Message should be displayed in phpMyAdmin stating the row was updated. The user account should be able to login with the new password.

Click to comment

Leave a Reply

Your email address will not be published.

You May Also Like


Setting up NGINX with a free Let’s Encrypt SSL certificate is a breeze using Docker and the container maintained by The default setup...


Plex updated it’s support of collections at the end of 2017 by letting the user choose to group movies in a collection ie. Star...


Configure the TP-Link AX50 router so that it can be shared between both Windows and Linux. The router has USB sharing built into the...


Cloudflare has plenty to offer even to free users. I looked into some methods of improving the TTL or time to first byte as...

Copyright © 2021 Carl Peterson. Theme by MVP Themes, powered by WordPress.