CODE EXAMPLE FOR PHP

reset admin password magento 2

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

The xxxxxxx character sequence is a cryptographic salt, it is saved in appetcenv.php file

<?php
...
  'crypt' => [
      'key' => 'f323fedda15153db7783e4610137a581'
  ],
...
?>