Magento 2.x: How to reset Customer Password from Database


If you need to reset the password of a certain customer via Database, the following query will help you:

Just change ‘YOURPASSWORD’ above (keep the xxxxx).