In this post, I will elaborate 3 ways to work around when losing Magento 2 admin password.
Table of Contents
Method 1. Web interface
This is the quickest way to reset your Magento 2 admin password.
First, go to your admin login page:
Then, click the Forgot your password ?
Now, you will enter a new page where you can enter the email you want to receive your new Magento Admin password, then click Retrieve Password button:
+) If your email is correct, Magento system will automatically send a confirm email to your email, then you need to click and the link will redirect to the Magento reset password page. The link is valid in 24 hours.
Finally, enter 2 fields are New password and Confim New Password
Method 2: CLI
To get started, login to your server with SSH, then go to the folder root of site.
Next, create a new admin user by using the command below:
php bin/magento admin:user:create --admin-user="demo" --admin-password="demo123" --admin-email="[email protected]" --admin-firstname="Lof of" --admin-lastname="Coder"
+) Login to admin panel using the new account, then change the password of account that you lost
Also, check more detail at http://devdocs.magento.com/guides/v2.0/install-gde/install/cli/install-cli-subcommands-admin.html
Method 3: phpMyadmin
We can reset your Magento 2 admin password directly through the database of your website application. So, changing Magento 2 admin password using database is very easy. All you need to do is to log in to the phpMyadmin cpanel and select the database of your site. Then, check the database name using for your site in file <folder_root>/app/etc/env.php and find the field ‘dbname’ => ‘CURRENT_DATABASE’,
Now, run the query below to set new password for account that you lost:
UPDATE `admin_user` SET `password` = MD5('NEWPASSWORD') WHERE `username` = 'ADMINUSERNAME';
Admin_user: this is database table from the Magento database.
NEWPASSWORD: the new password which you want to be set.
ADMINUSERNAME: your Magento admin username
Execute the query and your new password will be set.
Hope that the tutorials will support you well in retrieving Magento 2 Admin Password. If you have any feedback, please leave it in the comment section down below.