In case you forgot or don't know the password of the Magento administration user:

  • Go to the administration link for your store
  • Click on Forgot your password
  • Enter your email address (the address associated with your account)
  • Click on Retrieve Password - you will receive an email at the specified address where you can reset the password

Magento 2

Reset password directly from database:

  • Log in to cPanel
  • Database section - click on phpMyAdmin
  • Locate the database used by Magento and then click on SQL
UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxxNewpassword', 256), ':xxxxxxxx:1') WHERE username = 'admin';

In cazul in care folositi prefixe pentru tabele - ex rf:

UPDATE rf_admin_user SET password = CONCAT(SHA2('xxxxxxxxNewpassword, 256), ':xxxxxxxx:1') WHERE username = 'admin';
  • Replace Newpassword - with the desired password
  • xxxxxxxx - with a string (must be identical in both fields)
  • press the Go button

 

Using CLI

- Log in to the SSH console

- Navigate to the location where you installed Magento

Retrieve the admin user information from the database using the commands below:

echo "select email,firstname,lastname from admin_user where username='[admin]'" | mysql -u [db_user] [db_name] -p

a) Replace [db_user] - with the database user name
b) Replace [db_name] - with the database name
c) username = "[admin]" - replace [admin] with the name of the user you want to reset - You will need to enter the database user password

To reset the password use the command below replacing the fields with the desired ones:

php bin/magento  admin:user:create --admin-user="[admin]" --admin-password="[nouaparola]" --admin-email="[[email protected]]"  --admin-firstname="[Test]" --admin-lastname="[Test]

 

If you encounter problems in applying the above instructions please contact us. HostX offers the best Magento web hosting service and can assist you in solving your problems.

Was this answer helpful? 0 Users Found This Useful (0 Votes)