Forgot Admin password - reset it and still cannot log into web ui

[dawsonsp]

Hi All,

I forgot my "Admin" password so reset it (or at least I think I have) but still cannot log into the WebUI :-(. I used the following commands

:~$ mysql -u root -p
mysql > use zabbix
mysql > update users set passwd=md5('YOUR_NEW_PASSWORD') where username='Admin';
mysql > Rows matched: 1 Changed: 1 Warnings: 0

But when I try to login using "Admin" and new password I get

"Incorrect user name or password or account is temporarily blocked."

I am at a loss as to where to look next -

Regards
Scott

[dawsonsp]

Resolved ! - I used the following

UPDATE zabbix.users AS a
INNER JOIN zabbix.users AS b ON b.username='guest'
SET a.passwd = b.passwd;