Unable to change ADMIN password

Day-to-Day Users
23

Try changing the password column in table users_secure for the username wanted to change to:
$2y$10$6nlFnmFSwPYq/y7E8jhbX.ijYCIX7M4J9cmkQupzs.uHm4z8F.x7O

This is for user admin so if this doesn’t work(unsure if we include username in encryption) let me know.

Umm you did run sql_upgrade.php from browser, right?

24

That worked, thank you very much! Yes, I ran the sql_upgrade.php, I had been using the system for a while, but at one point I was working in the users screen, and I was kicked out, presented with the login screen, and I couldn’t log back in.

25

You’re welcome @stephengreen,
Now ensure you, or anyone else using this solution, to reset the password using the strong password option in Globals.

26

Hi. what password does “$2y$10$6nlFnmFSwPYq/y7E8jhbX.ijYCIX7M4J9cmkQupzs.uHm4z8F.x7O” translate to?

27

i get an empty set when i run select id from users where username = ‘ADMIN USER NAME’;

28

Hy, did you changed the password ?