Reseting Zabbix Admin password

If you ever lose / forget or inherit someones Zabbix install, you can easily reset the password for the admin user with a simple mysql query.

Procedure

1. Log into your mysql database:

mysql -u root -p 

2. Reset the password:

use zabbix;
update zabbix.users set passwd=md5('newpass') where alias='Admin';

3. Log into the web GUI with your new password.