Invalid User Name or Password [closed]

Question

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?

Answer 1

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.