OJS 3 Can't Login

The hosting tech team reset the password for me since I have no idea on
“UPDATE users SET password=SHA1(CONCAT(username,‘newPasswordHere’)) WHERE username=‘usernameHere’;”
I can login until now as admin. However, a new issue comes up. I just try to register with different email. I login but it does not work. It says invalid username or password. How i can solve this?