1

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?

3

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.

| improve this answer | |
  • if this answer solve your query than accept and +1 this will help to other to solve future query to other buddies. – Denish Vachhani Apr 16 '16 at 7:23

Not the answer you're looking for? Browse other questions tagged or ask your own question.