解决：Zabbix密码忘记不要慌，一招教你搞定

最新推荐文章于 2025-05-03 17:24:21 发布

胖胖不胖、

最新推荐文章于 2025-05-03 17:24:21 发布

阅读量7.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： # 《遇到过的问题》文章标签： zabbix 监控运维

本文链接：https://blog.youkuaiyun.com/yeyslspi59/article/details/128215418

《遇到过的问题》专栏收录该内容

19 篇文章

订阅专栏

本文介绍了一种解决Zabbix登录失败的方法，通过数据库操作来重置管理员密码。包括连接Zabbix数据库、查询用户信息、生成新密码及更新数据库记录等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Zabbix登录报错：Incorrect user name or password or account is temporarily blocked.

如下图（实在想不起密码不要紧我们直接重新设置它）：

1.登入zabbix数据库

[root@SJYS-Test1 ~]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.

2.进入zabbix库，查询users用户表

MariaDB [(none)]> use zabbix;
MariaDB [zabbix]> select * from  users;
+--------+----------+--------+---------------+--------------------------------------------------------------+-----+-----------+------------+---------+---------+---------+----------------+--------------+---------------+---------------+----------+--------+
| userid | username | name   | surname       | passwd                                                       | url | autologin | autologout | lang    | refresh | theme   | attempt_failed | attempt_ip   | attempt_clock | rows_per_page | timezone | roleid |
+--------+----------+--------+---------------+--------------------------------------------------------------+-----+-----------+------------+---------+---------+---------+----------------+--------------+---------------+---------------+----------+--------+
|      1 | Admin    | Zabbix | Administrator | $2y$10$92nDno4n0Zm7Ej7Jfsz8WukBfgSS/U0QkIuu8WkJPihXBb2A1UrEK |     |         1 | 0          | default | 30s     | default |              7 | 172.16.20.45 |    1670376817 |            50 | default  |      3 |
|      2 | guest    |        |               | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |     |         0 | 15m        | default | 30s     | default |              0 |              |             0 |            50 | default  |      4 |
+--------+----------+--------+---------------+--------------------------------------------------------------+-----+-----------+------------+---------+---------+---------+----------------+--------------+---------------+---------------+----------+--------+
2 rows in set (0.000 sec)

3.生成一个md5类型的新密码

[root@SJYS-Test1 ~]# echo -n admin | openssl md5
(stdin)= a3a0bd42393fe9b382271ddba191a440

4.更新表数据Admin用户的密码，并重新加载表权限

MariaDB [zabbix]> update users set passwd='a3a0bd42393fe9b382271ddba191a440' where userid = '1';
Query OK, 1 row affected (0.001 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [zabbix]> flush  privileges;
Query OK, 0 rows affected (0.001 sec)

5.登录