{"id":226368,"date":"2020-01-28T10:11:43","date_gmt":"2020-01-28T10:11:43","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=226368"},"modified":"2020-01-28T10:11:44","modified_gmt":"2020-01-28T10:11:44","slug":"how-to-change-magento-admin-password-through-database-in-magento2","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/","title":{"rendered":"How to change Magento admin password through Database in magento2"},"content":{"rendered":"\n<p>We will see how to change the Magento admin password through the database, In case if registered email for admin is not accessible and admin user not able to get the reset link because of mail not accessible then you can follow these steps to change the Magento admin password.<\/p>\n\n\n\n<p><strong>Steps:-<\/strong><\/p>\n\n\n\n<p>Run this query into respected DB of Magento<br><strong>UPDATE admin_user SET password = CONCAT(SHA2(&#8216;xxxxxxxNewPassword&#8217;, 256), &#8216;:xxxxxxx:1&#8217;) WHERE username = &#8216;admin&#8217;;<\/strong><br>NewPassword = enter your custom password(where NewPassword is your custom password for Magento admin account).<br>Where The xxxxxxx character sequence is a cryptographic salt, it is saved in app\\etc\\env.php file<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">&lt;?php\nreturn &#091;\n    &#039;backend&#039; =&gt; &#091;\n        &#039;frontName&#039; =&gt; &#039;admin&#039;\n    ],\n    &#039;crypt&#039; =&gt; &#091;\n        &#039;key&#039; =&gt; &#039;49d78c991b6c99ed48d046ec614d20cc&#039; \/\/cryptographic salt\n    ],<\/pre>\n\n\n\n<p>After the password changed and try to login with a new password and if you are getting the error message (The account sign-in was incorrect or your account is disabled temporarily. Please wait and try again later.)<br>Then run these command in Magento root directory:-<br><code><strong>php bin\/magento admin:user:unlock adminusername<\/strong><\/code><br>and try to login again.<br>Thanks \ud83d\ude42.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will see how to change the Magento admin password through the database, In case if registered email for admin is not accessible and admin user not able to get the reset link because of mail not accessible then you can follow these steps to change the Magento admin password. Steps:- Run this query into <a href=\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":308,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-226368","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to change Magento admin password through Database in magento2 - Webkul Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to change Magento admin password through Database in magento2 - Webkul Blog\" \/>\n<meta property=\"og:description\" content=\"We will see how to change the Magento admin password through the database, In case if registered email for admin is not accessible and admin user not able to get the reset link because of mail not accessible then you can follow these steps to change the Magento admin password. Steps:- Run this query into [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-28T10:11:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-28T10:11:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Tripuresh Kumar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tripuresh Kumar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/\"},\"author\":{\"name\":\"Tripuresh Kumar\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/6d211d122b6e683ac770d40eb518c312\"},\"headline\":\"How to change Magento admin password through Database in magento2\",\"datePublished\":\"2020-01-28T10:11:43+00:00\",\"dateModified\":\"2020-01-28T10:11:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/\"},\"wordCount\":169,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/\",\"url\":\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/\",\"name\":\"How to change Magento admin password through Database in magento2 - Webkul Blog\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"datePublished\":\"2020-01-28T10:11:43+00:00\",\"dateModified\":\"2020-01-28T10:11:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to change Magento admin password through Database in magento2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/6d211d122b6e683ac770d40eb518c312\",\"name\":\"Tripuresh Kumar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fc67e5b5422592541e9f33de1541222f1b10c41d2d0b960647132aa3ba3cf9d5?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fc67e5b5422592541e9f33de1541222f1b10c41d2d0b960647132aa3ba3cf9d5?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"caption\":\"Tripuresh Kumar\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/tripuresh-kumar218\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to change Magento admin password through Database in magento2 - Webkul Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/","og_locale":"en_US","og_type":"article","og_title":"How to change Magento admin password through Database in magento2 - Webkul Blog","og_description":"We will see how to change the Magento admin password through the database, In case if registered email for admin is not accessible and admin user not able to get the reset link because of mail not accessible then you can follow these steps to change the Magento admin password. Steps:- Run this query into [...]","og_url":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2020-01-28T10:11:43+00:00","article_modified_time":"2020-01-28T10:11:44+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png","type":"image\/png"}],"author":"Tripuresh Kumar","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Tripuresh Kumar","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/"},"author":{"name":"Tripuresh Kumar","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/6d211d122b6e683ac770d40eb518c312"},"headline":"How to change Magento admin password through Database in magento2","datePublished":"2020-01-28T10:11:43+00:00","dateModified":"2020-01-28T10:11:44+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/"},"wordCount":169,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/","url":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/","name":"How to change Magento admin password through Database in magento2 - Webkul Blog","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"datePublished":"2020-01-28T10:11:43+00:00","dateModified":"2020-01-28T10:11:44+00:00","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/how-to-change-magento-admin-password-through-database-in-magento2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to change Magento admin password through Database in magento2"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/6d211d122b6e683ac770d40eb518c312","name":"Tripuresh Kumar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fc67e5b5422592541e9f33de1541222f1b10c41d2d0b960647132aa3ba3cf9d5?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fc67e5b5422592541e9f33de1541222f1b10c41d2d0b960647132aa3ba3cf9d5?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","caption":"Tripuresh Kumar"},"url":"https:\/\/webkul.com\/blog\/author\/tripuresh-kumar218\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/226368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/308"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=226368"}],"version-history":[{"count":17,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/226368\/revisions"}],"predecessor-version":[{"id":226401,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/226368\/revisions\/226401"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=226368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=226368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=226368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}