Admin login is one of the issue due to forgot password therefore i am getting to change or reset password of admin.
1) From admin login
a. Log in to magento admin.
c. Go to the System>My Account
d. There are fields where you can enter your New Password.
e. Then click on Reset button & Save account.
2) From direct change in database
If you want to reset admin password by run sql in database, just run at your sql database:
SELECT * FROM admin_user;
Then, find the username you want to modify in the listing provided – ‘admin’ in this example. Then, to update the password, type:
UPDATE admin_user SET password=CONCAT(MD5('qXadmin123'), ':qX') WHERE username='admin';
After excuted above sql,your password is ‘admin123’ so that you can login ‘admin’ as username and ‘admin123’ as password.
NOTE : ‘qX’ would be changed to whatever you want it to be and same goes for ‘admin123’
Thank You
