magento2 update admin password phpmyadmin code example

Example 1: create admin password in magento 2

bin/magento admin:user:create --admin-user="admin2" --admin-password="admin123" --admin-email="[email protected]" --admin-firstname="Amin" --admin-lastname="Admin"

Example 2: 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 app\etc\env.php file

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