{"id":342,"date":"2021-09-05T09:18:34","date_gmt":"2021-09-05T03:33:34","guid":{"rendered":"https:\/\/yoho.cloud\/blog\/?p=342"},"modified":"2021-09-05T09:29:41","modified_gmt":"2021-09-05T03:44:41","slug":"reset-wordpress-passwords-using-phpmyadmin","status":"publish","type":"post","link":"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/","title":{"rendered":"How to Reset WordPress Admin Passwords Using Phpmyadmin ?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/#1_Login_into_Cpanel\" >1) Login into Cpanel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/#2_Scroll_to_the_DATABASES_section_and_click_on_phpMyAdmin\" >2 ) Scroll to the DATABASES section and click on phpMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/#3_Click_on_your_WordPress_Database_name_on_the_left\" >3 ) Click on your WordPress Database name on the left.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/#4_Click_on_the_wp_users_table\" >4 ) Click on the wp_users table.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/#5_Click_on_Edit\" >5) Click on Edit.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/#6_Enter_your_password_into_the_user_pass_field_Select_MD5_from_the_drop-down_lists\" >6 ) Enter your password into the user_pass field. Select MD5 from the drop-down lists.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/#7_Click_on_Go_to_continue\" >7 ) Click on Go to continue<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/yoho.cloud\/blog\/reset-wordpress-passwords-using-phpmyadmin\/#8_A_success_message_will_now_appear_from_phpMyAdmin_saying_that_the_database_record_was_updated\" >8 ) A success message will now appear from phpMyAdmin saying that the database record was updated.<\/a><\/li><\/ul><\/nav><\/div>\n<p>If you forget your WordPress password, then no need to worry as you can easily change your WordPress user&#8217;s password using phpMyAdmin in cPanel. Follow the following steps to change <strong>WordPress user&#8217;s passwords using phpMyAdmin<\/strong> in cPanel.<\/p>\n<h3>Steps to Change WordPress Password Using Phpmyadmin :<\/h3>\n<h4><span class=\"ez-toc-section\" id=\"1_Login_into_Cpanel\"><\/span>1) Login into Cpanel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>You need to login into Cpanel with login details provided by the web hosting provider. You can easily login into CPanel by any the method URL :<\/p>\n<p style=\"text-align: center;\">\u00a0https:\/\/www.yourdomain.com:2083<\/p>\n<p>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 https:\/\/www.yourdomain.com\/cpanel<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-343 size-large\" src=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/Cpanel-login-1-500x350.png\" alt=\"\" width=\"500\" height=\"350\" \/><\/p>\n<h4><span class=\"ez-toc-section\" id=\"2_Scroll_to_the_DATABASES_section_and_click_on_phpMyAdmin\"><\/span><span style=\"font-weight: 400;\">2 ) <\/span><span style=\"font-weight: 400;\">Scroll to the <\/span><b>DATABASES <\/b><span style=\"font-weight: 400;\">section and click on <\/span><b>phpMyAdmin<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-344\" src=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/db-section-cpanel.png\" alt=\"\" width=\"512\" height=\"66\" srcset=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/db-section-cpanel.png 512w, https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/db-section-cpanel-150x19.png 150w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<h4><span class=\"ez-toc-section\" id=\"3_Click_on_your_WordPress_Database_name_on_the_left\"><\/span><span style=\"font-weight: 400;\">3 ) Click on your WordPress Database name on the left.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-345\" src=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/phpmyadmin.png\" alt=\"\" width=\"512\" height=\"174\" srcset=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/phpmyadmin.png 512w, https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/phpmyadmin-150x51.png 150w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<h4><span class=\"ez-toc-section\" id=\"4_Click_on_the_wp_users_table\"><\/span><span style=\"font-weight: 400;\">4 ) Click on the <strong>wp_users<\/strong> table.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h4><span class=\"ez-toc-section\" id=\"5_Click_on_Edit\"><\/span>5) <span style=\"font-weight: 400;\">Click on Edit.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-346\" src=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/phpadmin-users.png\" alt=\"\" width=\"512\" height=\"176\" srcset=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/phpadmin-users.png 512w, https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/phpadmin-users-150x52.png 150w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<h4><span class=\"ez-toc-section\" id=\"6_Enter_your_password_into_the_user_pass_field_Select_MD5_from_the_drop-down_lists\"><\/span><span style=\"font-weight: 400;\">6 ) Enter your password into the user_pass field. Select MD5 from the drop-down lists.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-347\" src=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/MD5-phpmyadmin.png\" alt=\"\" width=\"512\" height=\"77\" srcset=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/MD5-phpmyadmin.png 512w, https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/MD5-phpmyadmin-150x23.png 150w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<p>After choosing MD5, you can enter the new password of that user.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"7_Click_on_Go_to_continue\"><\/span><span style=\"font-weight: 400;\">7 ) Click on <strong>Go <\/strong>to continue<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-348\" src=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/password-change-user.png\" alt=\"\" width=\"512\" height=\"107\" srcset=\"https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/password-change-user.png 512w, https:\/\/yoho.cloud\/blog\/wp-content\/uploads\/2021\/09\/password-change-user-150x31.png 150w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<h4><span class=\"ez-toc-section\" id=\"8_A_success_message_will_now_appear_from_phpMyAdmin_saying_that_the_database_record_was_updated\"><\/span><span style=\"font-weight: 400;\">8 ) A success message will now appear from phpMyAdmin saying that the database record was updated.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Thus like this, you changed your WordPress user&#8217;s password using PHPMyAdmin and this method is only recommended if you have forgotten the WordPress admin password.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you forget your WordPress password, then no need to worry as you can easily change your WordPress user&#8217;s password using phpMyAdmin in cPanel. Follow the following steps to change WordPress user&#8217;s passwords using phpMyAdmin in cPanel. Steps to Change WordPress Password Using Phpmyadmin : 1) Login into Cpanel You need to login into Cpanel [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":349,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,39],"tags":[42,41,28],"class_list":["post-342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledge-base","category-wordpress","tag-phpmyadmin","tag-reset-password","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/posts\/342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/comments?post=342"}],"version-history":[{"count":3,"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/posts\/342\/revisions"}],"predecessor-version":[{"id":351,"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/posts\/342\/revisions\/351"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/media\/349"}],"wp:attachment":[{"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/media?parent=342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/categories?post=342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yoho.cloud\/blog\/wp-json\/wp\/v2\/tags?post=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}