Reset Zabbix 6.2 admin password

I found myself needing to reset the Admin password for Zabbix, but every tutorial I found was for an older version and no longer worked. This works for Zabbix 6.2.

• Connect to the MySQL database.

mysql -u root -p

• Use the Zabbix database.

use zabbix;

• Set "Admin" password same as "guest".

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

• Restart Zabbix.

sudo systemctl restart zabbix-server

• Login with username "Admin" and no password.
• Change the password for "Admin"