The passwords are encrypted and not stored in plain-text so resetting to something like 'test123' will never work.
What you will need to do is reset it to NULL (do not put quotes around the word NULL).
After this you should be able to log in with a blank password and then update it to a known value.
Thanks lot Alex.
Its perfect solution.