Magento 1.9 – How to Update Customer Password Directly in Database

customer-attributedatabasemagento-1.9password

If I have access to my database, can I manually override a customer password? This is my local development environment.

I have little knowledge of password encryption but I would like to be able to log out on a previously setup customer account and my forgot password link is not working.

As far as I can see this is stored in the customer_entity_varchar table.

Best Answer

Try this:

Replace testtest with your new password and $customer_entity_id with the customers entity_id in the customer_entity table.

update customer_entity_varchar set value = md5('testtest') where entity_id=$customer_entity_id and attribute_id in (select attribute_id from eav_attribute where attribute_code = 'password_hash' and entity_type_id = 1);

Related Solutions

Magento 2 – Add Custom Customer Attribute Field for REST API

The custom attribute mobile_number should be inside custom customer attribute data:

{
  "customer": {
    "email": "person@email.net",
    "firstname": "First",
    "lastname": "Last",
    "storeId": 1,
    "websiteId": 1,
    "custom_attributes": [
     {
       "attribute_code": "mobile_number",
       "value": "23456798"
     }
    ]
  },
  "password": "Abc@123456"
}

Magento 2 – Fix Error When Updating Admin Password

I was able to resolve this issue by going into the admin_passwords table, and removing the stored passwords associated with the admin users' ID.

Not sure if this was the right way to go about it, but it solved this issue and hasn't caused any adverse effects, as far as I can tell.

Best Answer

Related Solutions

Magento 2 – Add Custom Customer Attribute Field for REST API

Magento 2 – Fix Error When Updating Admin Password

Related Topic