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

admin

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

2 }! X$ S% I& ]4 P* h  l* a首先登录数据库
! Y2 J! K4 c3 m1 K
+ L8 ?) R7 a4 J. p/ y[root@zabbix-server conf]# mysql -uzabbix -p
mysql: [Warning] Using a password on the command line interface can be insecure.
: |$ M  Z- ^+ ~0 [- j8 m' AWelcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 50
4 K2 y1 U3 W+ BServer version: 8.0.40 MySQL Community Server - GPL
& k1 I, S) g' N
3 g# c( o7 t3 ICopyright (c) 2000, 2024, Oracle and/or its affiliates.
! s  k) X/ p/ o& E: M# M
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
( J# `$ P5 O/ t) N, d" e% Q3 rowners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
3 Q6 I0 b: {. ]
2 ?3 z6 s$ _9 ^9 \4 Qmysql> show databases;
+--------------------+
; b/ i( p% m- C! H| Database           |
' m. q; k6 u: i% s+--------------------+
| information_schema |
| performance_schema |
, l' F1 F3 V  h" c| zabbix             |
" t; q  i  B8 n1 U  X+ U! M; D+--------------------+
1 b7 D) S* ^% L0 j$ E* R$ v0 @3 rows in set (0.01 sec)
' ~* n% H$ U& k0 c' Y5 s8 z' Z
; A  ]7 u% v: o2 umysql> use zabbix
Reading table information for completion of table and column names
5 F" X' h4 }/ Y$ }. fYou can turn off this feature to get a quicker startup with -A
8 i: A: p: t& p6 Y4 P$ ^6 {3 N9 V- J7 O
" o- Z: F) L' @3 M6 B5 z2 TDatabase changed

3 Z& ~6 ^0 K3 h) C+ t
2 T7 m: L( d0 _, Q8 Z7 n
mysql> select userid,username,name,passwd from users;
+--------+----------+--------+--------------------------------------------------------------+
9 u2 r' Y  h* Y% b  k+ U| userid | username | name   | passwd                                                       |
2 e8 S/ W! Q. R. e3 P1 d( E+--------+----------+--------+--------------------------------------------------------------+
$ s" \3 m! {& j$ R. e|      1 | Admin    | Zabbix | $2y$10$92nDno4n0Zm7Ej7Jfsz8WukBfgSS/U0QkIuu8WkJPihXBb2A1UrEK |
|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
" @  f0 w. t) r- B* a+--------+----------+--------+--------------------------------------------------------------+
! Y, s) y0 \' _) _2 rows in set (0.00 sec)
5 a8 n3 V; m& o- J+ A
4 j! J4 E/ b. W0 \* G4 Cmysql> update users set passwd=MD5('victors123') where username='admin';
& N$ X0 T$ n  Q" z7 jQuery OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0
% B- w% Y3 r% `* |


( H" y! s! S' u1 h9 F! u% f/ v
. n8 A' S4 O/ s6 Y6 m( M8 k1 M! Y

admin

mysql> update users set passwd=MD5('victors123') where username='Admin';
9 b1 x' f6 e' V0 }1 e) U" p4 s+ dQuery OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
& m' ^3 |  p' X  F! U8 Q0 ^
mysql> select userid,username,name,passwd from users;
+--------+----------+--------+--------------------------------------------------------------+
| userid | username | name   | passwd                                                       |
+--------+----------+--------+--------------------------------------------------------------+
|      1 | Admin    | Zabbix | f82d61a5bae93646df737371905f8d20                             |
|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
+--------+----------+--------+--------------------------------------------------------------+
7 o, M. q5 w' ?) b" z2 W; Q2 rows in set (0.00 sec)
2 S+ Q6 z! o9 j* Z, M. d% V+ s

admin

echo -n admin |openssl md5
' i) t. q  r0 V& @(stdin)= 21232f297a57a5a743894a0e4a801fc3

+ }4 @1 _+ w' [mysql> update users set passwd='21232f297a57a5a743894a0e4a801fc3' where userid='1';
) b1 V& H+ P% _" g5 f, w: f& bQuery OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
  I/ v, r& }% X' s$ i
5 _: n: d, v* Q+ Xmysql> flush privileges;
+ p) K/ l/ `0 v7 O& w8 n. j$ O/ ^) XQuery OK, 0 rows affected (0.02 sec)