I am sharing below MYSQL query for update Magento2 admin user’s password. Change ‘yournewpassoword’ into your password and ‘admin’ our username. And then run it on your mysql. your password will change.

UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxYournewpassword', 256), ':xxxxxxx:1') WHERE username = 'admin';