忘记zabbix登录密码

zabbix默认用户名是Admin，在忘记登录密码的情况下，进入数据库去修改。

对应的库是zabbix，对应的表示users。

mysql> select * from zabbix.users;
+--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+------------+----------------+-----------------+---------------+---------------+
| userid | alias | name   | surname       | passwd                           | url | autologin | autologout | lang  | refresh | type | theme      | attempt_failed | attempt_ip      | attempt_clock | rows_per_page |
+--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+------------+----------------+-----------------+---------------+---------------+
|      1 | Admin | Zabbix | Administrator | 291dcw24ffpcfe70e36bb33476f16d19 |     |         1 | 0          | zh_CN | 30s     |    3 | dark-theme |              0 | 117.153.143.109 |    1585878380 |            50 |
|      2 | guest |        |               | d41d8cd98f00pl04e989jn98ecf8427e |     |         0 | 15m        | en_GB | 30s     |    1 | default    |              0 |                 |             0 |            50 |
+--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+------------+----------------+-----------------+---------------+---------------+
2 rows in set (0.00 sec)

生成新的md5密码

[root@php ~]# echo -n test123|openssl md5
(stdin)= cc03e747a6afbbcbf8be7668acfebee5

更新密码

mysql> update users set passwd='cc03e747a6afbbcbf8be7668acfebee5' where userid=1; 
Query OK, 0 rows affected (0.01 sec) 
Rows matched: 1 Changed: 0 Warnings: 0 

mysql> flush privileges; 
Query OK, 0 rows affected (0.06 sec)

此时通过test123即可登录到zabbix