Zabbix 4 Network Monitoring - Third Edition

Managing users

We saw how managing users was an easy task using the frontend. But what if you have forgotten the password? What if some remote installation of Zabbix is administered by local staff, and the only Zabbix super admin has left for a month-long trip without a phone and nobody else knows the password? If you have access to the database, you can try to solve such problems. Let's find out what exactly Zabbix stores about users and how. In the MySQL console, execute this:

mysql> select * from users limit 2;

This way, we are listing all data for two users at the most:

The example output is trimmed on the right-hand side and fewer than ...