Global Admin Login Fail

[revnet]

Hi,
I have forgotten my Global Admin password, I have tried the following steps to reset the password:

update passwords set salt=null, value='$2a$10$yM.uw9jC7C1DrRGUhqUc3eSR6FCJH0.HdDt3CJs8YL56iATHcXH7.'
where user_id = (select id from users where username='admin') and status = 'ACTIVE' and password_type_id = 1;

Once done, I tried login to the Global Login page, using username: admin, password: 1234, that's where below error comes about:
org.cyclos.model.CyclosException

Any idea how to resolve this?
Am running on Cyclos 4.7


Thanks in advance.