Reset customer password in db
Posted on November 2, 2018, 1:17 pm, by admin, under
Magento 1.x.
UPDATE customer_entity_varchar SET VALUE = md5('new_password')
WHERE entity_id=(SELECT entity_id FROM customer_entity WHERE email='email@hostname.com')
AND attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'password_hash' AND entity_type_id = 1); |
UPDATE customer_entity_varchar SET value = md5('new_password')
WHERE entity_id=(SELECT entity_id FROM customer_entity WHERE email='email@hostname.com')
AND attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'password_hash' AND entity_type_id = 1);