{"id":1373,"date":"2019-07-25T02:38:30","date_gmt":"2019-07-24T23:38:30","guid":{"rendered":"https:\/\/saedx.com\/blog\/?p=1373"},"modified":"2019-07-25T02:55:23","modified_gmt":"2019-07-24T23:55:23","slug":"reset-a-wordpress-password-from-phpmyadmin-in-6-easy-steps","status":"publish","type":"post","link":"https:\/\/saedx.com\/blog\/reset-a-wordpress-password-from-phpmyadmin-in-6-easy-steps","title":{"rendered":"Reset a WordPress Password from phpMyAdmin in 6 easy steps"},"content":{"rendered":"<p>You lost your WordPress password and can not even reset it via email because you forgot email too, don&#8217;t worry there is a solution.<\/p>\n<p>Now you can reset a WordPress password via phpMyAdmin, here 6 easy steps to reset WordPress password it directly from the database using phpMyAdmin.<\/p>\n<p>It easily steps to reset a WordPress password from phpMyAdmin but if you are not familiar with database be careful or call the expert to do it for you.<\/p>\n<p>here the steps to reset a WordPress password via phpMyAdmin, if you just follow images instruction and mark&#8217;s you will succeed to do it.<\/p>\n<p><strong>1- login to phpMyAdmin<\/strong><br \/>\nIf you have access to your website cPanel or to your hosting account, log in to your cPanel then at the cPanel dashboard, click on the phpMyAdmin icon, it could be within the database section.<\/p>\n<p>If you are running a website using the local server like XAMPP, WAMPP or MAMPP, just go to http:\/\/localhost\/phpmyadmin\/, or find a link at first screen show to you when you run the program (control panel).<\/p>\n<p><strong>2- In phpMyAdmin, click on your WordPress database name which you need to reset its user password.<\/strong><\/p>\n<p><a href=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/1.jpg\" data-rel=\"penci-gallery-image-content\" ><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-1374\" src=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/1.jpg\" alt=\"\" width=\"374\" height=\"537\" srcset=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/1.jpg 374w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/1-209x300.jpg 209w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/1-200x287.jpg 200w\" sizes=\"(max-width: 374px) 100vw, 374px\" \/><\/a><\/p>\n<p><strong>3- From the list of tables shows for you find \u2018<span style=\"color: #ff0000;\">wp_users<\/span>\u2019 table then click on the \u2018<span style=\"color: #ff0000;\">Browse<\/span>\u2019 link next to it.<\/strong><\/p>\n<p><a href=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2.jpg\" data-rel=\"penci-gallery-image-content\" ><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1375\" src=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-1024x644.jpg\" alt=\"\" width=\"745\" height=\"469\" srcset=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-1024x644.jpg 1024w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-300x189.jpg 300w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-768x483.jpg 768w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-320x202.jpg 320w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-700x441.jpg 700w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-200x126.jpg 200w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-400x251.jpg 400w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-600x377.jpg 600w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2-800x503.jpg 800w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/2.jpg 1077w\" sizes=\"(max-width: 745px) 100vw, 745px\" \/><\/a><\/p>\n<p>Note: Table name may a different than (wp_users) it could be any text followed by (_users).<\/p>\n<p><strong>4- from WordPress users list shows to you, click on the <span style=\"color: #ff0000;\">edit<\/span> link of the username wants to change their password.<\/strong><\/p>\n<p><a href=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/3.jpg\" data-rel=\"penci-gallery-image-content\" ><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1376\" src=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/3.jpg\" alt=\"\" width=\"584\" height=\"460\" srcset=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/3.jpg 760w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/3-300x236.jpg 300w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/3-200x158.jpg 200w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/3-400x315.jpg 400w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/3-600x473.jpg 600w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<p><strong>5- from user information fields find <span style=\"color: #ff0000;\">user_pass<\/span> field under column header.<\/strong><br \/>\n<strong>Now, in the same <span style=\"color: #ff0000;\">user_pass<\/span> row:<\/strong><br \/>\n&#8211; Under the function header, select <span style=\"color: #ff0000;\"><strong>MD5<\/strong> <\/span>from the drop-down list.<\/p>\n<p><a href=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11.jpg\" data-rel=\"penci-gallery-image-content\" ><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1377\" src=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11.jpg\" alt=\"\" width=\"655\" height=\"491\" srcset=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11.jpg 920w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11-300x225.jpg 300w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11-768x576.jpg 768w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11-200x150.jpg 200w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11-400x300.jpg 400w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11-600x450.jpg 600w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/11-800x600.jpg 800w\" sizes=\"(max-width: 655px) 100vw, 655px\" \/><\/a><\/p>\n<p>&#8211; After you choose <em><span style=\"color: #ff0000;\">MD5<\/span><\/em> in <em><span style=\"color: #ff0000;\">user_pass<\/span><\/em>, in the same row under the value header, write your new password &#8211; typing.<\/p>\n<p><a href=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4.jpg\" data-rel=\"penci-gallery-image-content\" ><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1378\" src=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4-1024x79.jpg\" alt=\"\" width=\"711\" height=\"55\" srcset=\"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4-1024x79.jpg 1024w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4-300x23.jpg 300w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4-768x59.jpg 768w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4-200x15.jpg 200w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4-400x31.jpg 400w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4-600x46.jpg 600w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4-800x62.jpg 800w, https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/4.jpg 1047w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/a><\/p>\n<p><strong>6- scroll page down, click <span style=\"color: #ff0000;\">Go<\/span> button.<\/strong><\/p>\n<p>Congratulations! Now try new WordPress password you set it using phpMyAdmin.<\/p>\n<p>&nbsp;<\/p>\n<p>When do you need to reset the WordPress password from phpMyAdmin?<br \/>\nReset WordPress password using phpMyAdmin it should be your last choice and if you want to that, we alert you should have good knowledge in using phpMyAdmin or follow above steps in this article carefully.<br \/>\nyou need to using phpMyAdmin to reset WordPress password in these cases:<br \/>\n&#8211; You cannot reset WordPress password via regular way, the regular way is when you enter \/wp-admin to login you see an option link (lost your password?), but you can&#8217;t be using this option happens when you forget your email of registered username, or maybe you forget email and username together but you still have access to cPanel.<\/p>\n<p>&#8211; Your website is in localhost, so if you forget a password at localhost no way to reset password in a regular way we had mentioned because in most cases sending email from localhost websites not working and that&#8217;s the common situation.<br \/>\nin localhost mean you run website using XAMPP or WAMPP for example.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You lost your WordPress password and can not even reset it via email because you forgot email too, don&#8217;t worry there is a solution. Now you can reset a WordPress&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1380,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":""},"categories":[12,11],"tags":[],"jetpack_featured_media_url":"https:\/\/saedx.com\/blog\/wp-content\/uploads\/2019\/07\/saedx-blog-featured-75.jpg","jetpack_shortlink":"https:\/\/wp.me\/p3wRFx-m9","_links":{"self":[{"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/posts\/1373"}],"collection":[{"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/comments?post=1373"}],"version-history":[{"count":2,"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/posts\/1373\/revisions"}],"predecessor-version":[{"id":1381,"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/posts\/1373\/revisions\/1381"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/media\/1380"}],"wp:attachment":[{"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/media?parent=1373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/categories?post=1373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saedx.com\/blog\/wp-json\/wp\/v2\/tags?post=1373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}