Even after using below command still facing same issue while login "Incorrect user name or password or account is temporarily blocked."
UPDATE zabbix.users AS a
INNER JOIN zabbix.users AS b ON b.username='guest'
SET a.passwd = b.passwd;
UPDATE zabbix.users AS a
INNER JOIN zabbix.users AS b ON b.username='guest'
SET a.passwd = b.passwd;