Change admin password in Magento


Current administrator password impossible to know, since it is not stored on the site in cleartext, only its hash is stored. The password can only be changed to a new one.
  1. Openup site database in phpMyAdmin.
  2. Execute SQL query (instead of new_password enter a new password instead of user - 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 the entrance to Adminpanel.