I have been unable to access my website this morning. Getting this message - Invalid User Name or Password. I have changed my password but it seems to be the username that's the issue. Can anyone help me?
-
are you asking about admin?– Denish VachhaniApr 16, 2016 at 7:09
-
Yes I am Denish– NatashaApr 16, 2016 at 7:11
-
nice question +1 for that.– Denish VachhaniApr 16, 2016 at 7:21
-
3Possible duplicate of How to reset lost admin password in Magento 2?– Fabian SchmenglerApr 16, 2016 at 11:05
1 Answer
If you are having troubles and want to reset it to a different password, just run at your sql database:
get your username with query
SELECT * FROM admin_user;
and than change password using query
UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';
if password = "admin1234" than define query like
UPDATE admin_user SET password=CONCAT(MD5('qXadmin1234'), ':qX') WHERE username='admin';
note:- check your username
I hope this will help you.
-
if this answer solve your query than accept and +1 this will help to other to solve future query to other buddies. Apr 16, 2016 at 7:23