2.14.13.4. Change administrator password in Magento

Attention!

The current administrator password cannot be retrieved because it is not stored on the site in plain text — only its hash is stored. The password can only be changed to a new one.
  1. Open site database in phpMyAdmin.
  2. Run the SQL query (instead of new_password specify the new password, instead of user specify the administrator login):
    SET @salt = MD5(UNIX_TIMESTAMP());
UPDATE admin_user SET `password` = CONCAT(SHA2(CONCAT(@salt, 'new_password'), 256), ':', @salt, ':1') WHERE username = 'user';
  3. Check login to the site admin panel.
Inhalt
    (1)