{"id":1128,"date":"2016-12-09T17:35:25","date_gmt":"2016-12-09T12:05:25","guid":{"rendered":"http:\/\/www.magewallet.com\/?p=1128"},"modified":"2020-03-13T16:04:31","modified_gmt":"2020-03-13T10:34:31","slug":"reset-admin-password-magento-2","status":"publish","type":"post","link":"https:\/\/www.hiddentechies.com\/blog\/magento-2\/reset-admin-password-magento-2\/","title":{"rendered":"How to reset admin password in Magento 2?"},"content":{"rendered":"<p>In order to reset the admin password from phpmyadmin in Magento 2, please follow below simple steps.<\/p>\n<p>1) Go to phpMyAdmin<br \/>\n2) Open table admin_user<br \/>\n3) Run the following sql query<\/p>\n<pre class=\"lang:default decode:true \">UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE username = 'admin';<\/pre>\n<p>Here, <strong>NewPassword<\/strong> -&gt; Replace it with your password.<\/p>\n<p>Thats it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In order to reset the admin password from phpmyadmin in Magento 2, please follow below simple steps. 1) Go to phpMyAdmin 2) Open table admin_user 3) Run the following sql query UPDATE admin_user SET password = CONCAT(SHA2(&#8216;xxxxxxxxNewPassword&#8217;, 256), &#8216;:xxxxxxxx:1&#8217;) WHERE username = &#8216;admin&#8217;; Here, NewPassword -&gt; Replace it with your password. Thats it.<\/p>\n","protected":false},"author":1,"featured_media":4736,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[154,155,9,10,24,28,156,45,157],"_links":{"self":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/1128"}],"collection":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/comments?post=1128"}],"version-history":[{"count":3,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/1128\/revisions"}],"predecessor-version":[{"id":10526,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/1128\/revisions\/10526"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/media\/4736"}],"wp:attachment":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/media?parent=1128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/categories?post=1128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/tags?post=1128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}