Do you want to reset your WordPress password using phpMyAdmin? If you are unable to reset your WordPress password, then there is a way to reset it directly in your WordPress database using phpMyAdmin. In this article, we will show you how to easily reset a WordPress password from phpMyAdmin in the cPanel.<\/span><\/p>\n

Why Reset WordPress Password from phpMyAdmin<\/span><\/h4>\n

WordPress makes it super easy to reset your password. You can simply go to the login screen and click on the \u2018Lost your password\u2019 link.<\/span><\/p>\n

<\/span><\/p>\n

Clicking on it takes you to password reset page where you can enter your username or email address to reset the password. After that WordPress sends a password reset link to the email address associated with that user account.\u00a0<\/span><\/p>\n

However, if you don\u2019t have access to the email address, or your\u00a0WordPress site fails to send an email, then you will not be able to reset your password.<\/span><\/p>\n

In such a situation, you will need to reset your WordPress password directly in the database. The easiest way to do that is by\u00a0using phpMyAdmin in the cPanel.<\/span><\/p>\n

Having said that, let\u2019s see how you can easily reset a WordPress password from phpMyAdmin in the cPanel.<\/span><\/p>\n

How to WordPress Password From PhpMyAdmin<\/span><\/h4>\n

First you need to login to the cPanel dashboard of your\u00a0WordPress hosting <\/a>account. Next, you need to click on the phpMyAdmin icon under the database section.<\/span><\/p>\n

<\/span><\/p>\n

This will launch the phpMyAdmin app where you need to select your WordPress database.<\/span><\/p>\n

<\/span><\/p>\n

You will now see the list of tables in your WordPress database. Now you need to look for the \u2018{table-prefix}_users\u2019 table in this list and click on the \u2018Browse\u2019 link next to it.<\/span><\/p>\n

<\/span><\/p>\n

Note: Table names in your WordPress database may have a different table prefix than the one we are showing in our screenshot.<\/span><\/p>\n

You will now see the rows in your WordPress users table. Go ahead and click on the edit button next to the username where you want to change the password.<\/span><\/p>\n

<\/span><\/p>\n

PhpMyAdmin will show you a form with all the user information fields as shown above.<\/span><\/p>\n

You will need to delete the value in the\u00a0user_pass<\/code>\u00a0field and replace it with your new password. Under the function column, select MD5 from the drop down menu and click on the Go button.<\/span><\/p>\n

<\/span><\/p>\n

Your password will be encrypted using the MD5 hash and then it will be stored in the database.<\/span><\/p>\n

You can now login into your wordpress dashboard using the new password.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Do you want to reset your WordPress password using phpMyAdmin? If you are unable to reset your WordPress password, then there is a way to reset it directly in your WordPress database using phpMyAdmin. In this article, we will show you how to easily reset a WordPress password from phpMyAdmin in the cPanel. Why Reset […]<\/p>\n","protected":false},"author":164,"featured_media":6890,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2397],"tags":[3374,3376,3375,3373],"class_list":["post-6889","post","type-post","status-publish","format-standard","has-post-thumbnail","category-wordpress","tag-reset-wordpress-password","tag-reset-your-wordpress-password-from-cpanel","tag-reset-your-wordpress-password-using-phpmyadmin","tag-wordpress-password-from-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/posts\/6889","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/users\/164"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/comments?post=6889"}],"version-history":[{"count":0,"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/posts\/6889\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/media\/6890"}],"wp:attachment":[{"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/media?parent=6889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/categories?post=6889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skytechng.com\/blog\/wp-json\/wp\/v2\/tags?post=6889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}