Zabbix Course 08 - Blocked user and password change of Zabbix web user in Mysql

Опубликовано: 03 Апрель 2026
на канале: Courses and Tips

18,571

215

In this video I will show you how to unlock a web interface user who is locked out of Zabbix via command line in Mysql. We will also see how to modify the password of a local user of the Zabbix web interface through the command line in the Mysql database.

⏰ TIMESTAMPS:
0:00 Zabbix Course 08 - Blocked user and password change of Zabbix web user in Mysql
0:18 Accessing the DB
0:43 Unlock Zabbix local web user
1:40 Change Zabbix local web user password

👉 USEFUL LINKS:

https://bcrypt-generator.com

✍ COMMANDS USED:

---* Unlock user : UPDATE users SET attempt_clock=0, attempt_failed=0 WHERE username='Admin';

***Note: for legacy versions of Zabbix, the column is "Alias", so the command would be: UPDATE users SET attempt_clock=0, attempt_failed=0 WHERE alias='Admin';

---* Change password: update zabbix.users set passwd='HASH-BCRYPT' where username='Admin';

***Note: for legacy versions of Zabbix, the column is "Alias", so the command would be:
update zabbix.users set passwd='HASH-BCRYPT' where alias='Admin';