How to Reset a WordPress Password from phpMyAdmin

The other day we had to reset the admin password for a client’s WordPress website. This can be easily done from phpMyAdmin.

Every WordPress website uses a so called MySQL Database which can be accessed and managed through phpMyAdmin. Once you’re in phpMyAdmin select the database for the WordPress install. In our example we’ll assume it’s the ‘goodwebsites’ database.

Look for a table wp_users and select it.

The default prefix is wp_. However, for security reasons it’s better to use a different prefix. So if the prefix was something like gwntts122_ then the user table entry to look for would be gwntts122_users.

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

By leaving a comment you agree with the storage and handling of your data by this website. You can learn more about how we handle you comment information in our Privacy Policy. We are using Akismet to reduce comment spam. Learn how they process your comment data.

Say Hello!

We’d love to hear about your website project. Please get in touch with us.