{"id":17036,"date":"2021-06-03T07:15:53","date_gmt":"2021-06-03T07:15:53","guid":{"rendered":"https:\/\/www.top-password.com\/blog\/?p=17036"},"modified":"2021-06-03T07:15:53","modified_gmt":"2021-06-03T07:15:53","slug":"reset-forgotten-wordpress-password-from-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.top-password.com\/blog\/reset-forgotten-wordpress-password-from-phpmyadmin\/","title":{"rendered":"How to Reset Forgotten WordPress Password from phpMyAdmin"},"content":{"rendered":"<p>Forgot the admin password of your WordPress blog? If you are locked out of your WordPress dashboard and couldn&#8217;t log back in, here is a simple way to reset forgotten WordPress password from phpMyAdmin. It works with all versions of WordPress.<\/p>\n<p><strong>How to Reset Forgotten WordPress Password from phpMyAdmin<\/strong><\/p>\n<ol>\n<li>Before getting started, you need to login to cPanel of your WordPress hosting account. Click on the <strong>phpMyAdmin<\/strong> icon under the Databases section.\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/cpanel.png\" alt=\"\" width=\"557\" height=\"322\" class=\"alignnone size-full wp-image-17042\" srcset=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/cpanel.png 557w, https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/cpanel-300x173.png 300w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/>\n<\/li>\n<li>When the phpMyAdmin app opens, expand your WordPress database on the left side, and then click on the <strong>wp_users<\/strong> table.\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/phpMyAdmin.png\" alt=\"\" width=\"243\" height=\"415\" class=\"alignnone size-full wp-image-17043\" srcset=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/phpMyAdmin.png 243w, https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/phpMyAdmin-176x300.png 176w\" sizes=\"auto, (max-width: 243px) 100vw, 243px\" \/>\n<\/li>\n<li>On the right side, you&#8217;ll see a list of registered users on your WordPress site. Click on the <strong>Edit<\/strong> button next to your WordPress admin user.\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/wordpress-user-accounts.png\" alt=\"\" width=\"600\" height=\"263\" class=\"alignnone size-full wp-image-17044\" srcset=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/wordpress-user-accounts.png 600w, https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/wordpress-user-accounts-300x132.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/>\n<\/li>\n<li>Look for the <strong>user_pass<\/strong> row. Remove the old password hash from the <strong>Value<\/strong> column and then type a new password (in plain text). Select <strong>MD5<\/strong> from the &#8220;<strong>Function<\/strong>&#8221; drop down menu.\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/reset-wordpress-admin-password.png\" alt=\"\" width=\"600\" height=\"210\" class=\"alignnone size-full wp-image-17045\" srcset=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/reset-wordpress-admin-password.png 600w, https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2021\/06\/reset-wordpress-admin-password-300x105.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/>\n<\/li>\n<li>Click on the <strong>Go<\/strong> button to save your changes. You can then log in to your WordPress dashboard with the new password. Upon your first successful login, WordPress will use the most up-to-date method instead of MD5 to encrypt your password again, and the hashed password stored in the database will update as well.<\/li>\n<\/ol>\n<p>That&#8217;s it!<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Forgot the admin password of your WordPress blog? If you are locked out of your WordPress dashboard and couldn&#8217;t log back in, here is a simple way to reset forgotten WordPress password from phpMyAdmin. It works with all versions of WordPress. How to Reset Forgotten WordPress Password from phpMyAdmin Before getting started, you need to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,1,10],"tags":[4679,4680,4677,4678],"class_list":["post-17036","post","type-post","status-publish","format-standard","hentry","category-free-software","category-others","category-tips-tricks","tag-forgot-wordpress-password","tag-reset-wordpress-admin-password","tag-reset-wordpress-password","tag-reset-wordpress-password-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/17036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/comments?post=17036"}],"version-history":[{"count":6,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/17036\/revisions"}],"predecessor-version":[{"id":17047,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/17036\/revisions\/17047"}],"wp:attachment":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/media?parent=17036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/categories?post=17036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/tags?post=17036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}