In this tutorial, you will go through how to reset customer password from database in magento2. This trick will be very useful and handy when you want to reset the customer password from database using mysql query.
"YOURPASSWORD" below (keep the xxx:es) and voila!
UPDATE `customer_entity` SET `password_hash` = CONCAT(SHA2('xxxxxxxxYOURPASSWORD', 256), ':xxxxxxxx:1') WHERE `entity_id` = 1;
I hope you like this post, Please feel free to comment below, your suggestion and problems!