How to Reset WordPress Password From phpMyAdmin

If you can’t login to your WordPress website by some reasons, you can reset your password via email by default. But in some cases, email address was hacked or unable to reset password via email, you can reset password from phpMyAdmin. WordPress CMS uses MySQL database and you can access these database through from phpMyAdmin. In this tutorial, I will guide you how to reset WordPress password from phpMyAdmin. Let’s start the journey.

• Login into your cPanel and click “phpMyAdmin”.

• Make sure to select correct database name and table prefix. If you have installed default table prefix setting, your table prefix will be wp_ . If you changed default table prefix name, you need to know specific table prefix name. Find users in tables. But these value bind with table prefix name. If you use default table prefix name, it will be “wp_users”. As an example, if you change table prefix name to “test”, table name will be “test_users”. Click “user” in table. Then, check the users table and click “edit”.

• Now you will see the fields user_login, password, email and others. In order to reset password, you need to replace password in user_pass field. You will see random numbers and texts in user_field. These numbers are MD5 Hash code. Due to security reason, WordPress doesn’t show password as plain text character. It shows with MD5 Hash values. To reset your password, you need to convert plain text character to MD5 Hash. There are a lot of online MD5 generator to generate the character. Go to md5hashgenerator.com to generate MD5 Hash values from plain text. Copy and replace generated MD5 Hash values to user_pass and click “Go” to proceed.

• Now you successfully changed your WordPress password. Re-login with changed password. Be enjoyable.