zabbix监控忘记admin登录密码解决方法

admin

zabbix监控忘记admin登录密码解决方法
5 }6 }8 T. T& I
首先登录数据库

4 s  w/ D$ O0 A5 l$ c# B% \4 u[root@zabbix-server conf]# mysql -uzabbix -p
mysql: [Warning] Using a password on the command line interface can be insecure.
! V; b7 J. Y9 K% {3 s3 rWelcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 50
Server version: 8.0.40 MySQL Community Server - GPL

" m  P, M/ y, v& SCopyright (c) 2000, 2024, Oracle and/or its affiliates.
6 p9 d. z. i: O. S5 s1 B6 Z: ?- X
1 E& H' X' q. r6 a2 l* XOracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
* }! L# ?7 i; s3 o" v! m; R
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
; {* \6 I8 B6 U% o" T7 a* _
mysql> show databases;
+--------------------+
* Y7 c* D; \, p. N- N9 n| Database           |
- w# p4 W" t- o# {' A+--------------------+
" O- u( [3 Z9 m9 P6 J3 k| information_schema |
| performance_schema |
; s5 v; T. }- r, {3 u* N6 i# g| zabbix             |
7 b- R% W! n$ w1 W1 I$ u+--------------------+
7 m- E0 o# s, e7 F3 rows in set (0.01 sec)

mysql> use zabbix
# @( ]4 _( e5 p/ _Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

$ b8 a/ s" B0 I3 f4 dDatabase changed

5 g1 V6 l8 K; [7 g$ X9 f

mysql> select userid,username,name,passwd from users;
+--------+----------+--------+--------------------------------------------------------------+
| userid | username | name   | passwd                                                       |
+--------+----------+--------+--------------------------------------------------------------+
7 B; t6 ~# N1 u6 ^1 S. A|      1 | Admin    | Zabbix | $2y$10$92nDno4n0Zm7Ej7Jfsz8WukBfgSS/U0QkIuu8WkJPihXBb2A1UrEK |
|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
+ j3 b7 d* G+ @6 J( l+--------+----------+--------+--------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> update users set passwd=MD5('victors123') where username='admin';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0


9 o7 i8 N4 T- r

4 }2 u7 [: Z! {# `1 K

admin

mysql> update users set passwd=MD5('victors123') where username='Admin';
, ?& [3 o7 @% K5 v3 [# m2 B, qQuery OK, 1 row affected (0.00 sec)
& S9 ?* w* [6 C) TRows matched: 1  Changed: 1  Warnings: 0

$ j- N8 A, A1 I5 p. l# qmysql> flush privileges;
, k4 X+ b0 v1 L8 ]2 t8 X: D1 ZQuery OK, 0 rows affected (0.02 sec)

mysql> select userid,username,name,passwd from users;
6 ]6 T5 e% V( u8 k& F" W+--------+----------+--------+--------------------------------------------------------------+
" ~! C7 v$ j( T- B8 L3 V: ~. z| userid | username | name   | passwd                                                       |
1 H9 k3 `, _9 F5 H, X* B+--------+----------+--------+--------------------------------------------------------------+
2 F0 C8 ]2 J: f& z+ @0 s% c: E|      1 | Admin    | Zabbix | f82d61a5bae93646df737371905f8d20                             |
|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
/ J. C/ p" v3 W5 W+--------+----------+--------+--------------------------------------------------------------+
2 rows in set (0.00 sec)

, w4 V6 M0 K6 ?. _# k5 l

admin

echo -n admin |openssl md5
(stdin)= 21232f297a57a5a743894a0e4a801fc3

mysql> update users set passwd='21232f297a57a5a743894a0e4a801fc3' where userid='1';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
# x# E, B4 g# l; F9 @6 p6 E# a4 l
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
9 @/ g  w$ T7 J/ S% `. o) {
, _; W; l% f1 z( Y1 m3 h  h0 T