How can I unlock a user if he was locked after entering the wrong pasword too many times? I checked is_active in customer_entity, but its always 1, even for locked users. Whats the right place to to that in the database?


  • Did you get any solution for unlock customer account? Please post answer here if any.
    – Yudi
    Commented Aug 1, 2018 at 4:31

2 Answers 2


If you are asking about admin users you can unlock them in System \ Permissions \ Locked Users.

Of cause you can also do it directly with a query like this:

UPDATE admin_user 
   SET failures_num = 0, lock_expires = NULL
 WHERE user_id = ?
  • 1
    No, I was talking about shop customers, not the admin users. Commented Mar 27, 2014 at 11:58

I've found solution to unlock customer account from Database. Search oauth_token_request_log table in your Magento2 DB and find the customer email whose account you want to unlock, and delete the row.

It will unlock customer account.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.