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.