You can reset admin password via phpmyadmin

  1. Login to phpmyadmin
  2. Choose your database
  3. Select ‘SQL’ tab and rub query:

UPDATE admin_user SET `password` = CONCAT(SHA2(‘xxxxxxxxYOUR_NEW_PASSWORD’, 256), ‘:xxxxxxxx:1’) WHERE `username` = ‘YOUR_ADMIN_USERNAME’;

Where admin_user – database table (it can containt table prefi – check it):

YOUR_NEW_PASSWORD – your new password

YOUR_ADMIN_USERNAME– your admin login name

Xxxxxxxx – character sequence is a cryptographic salt. it is saved in app\etc\env.php file:

<?php
return array (
  ...
  'crypt' => 
  array (
    'key' => '525701df74e6cba74d5e9a1bb3d935ad', //cryptographic salt
  ),

You can also resolve admin access issue by creating new admin user using magento console command:

php bin/magento admin:user:create

5.00 / 5.0
Article rating (4 Reviews)
Do you find this article useful? Please, let us know your opinion and rate the post!
Not badGoodVery GoodGreatAwesome