Magento 2 – How to Change Customer Password from Database

In this post I am going to explain how to change customer password from database in magento 2.

Go to phpmyadmin and copy the following sql query.

UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2('xxxxxxxxYOURPASSWORD', 256), ':xxxxxxxx:1')
WHERE `entity_id` = 1;

Change the “entity_id” with your id and just change “YOURPASSWORD” (keep the xxxxxxxx) with your new password.

Thats it. Enjoy Magento 2!!

Team HiddenTechies

Write an article about ecommerce that help people to grow their ecommerce business. You’ll find best ecommerce guide, news, tips & more!