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

admin

zabbix监控忘记admin登录密码解决方法
! H0 k) o& {4 _& F" Y
0 k1 \/ A/ t: X% N) K3 S首先登录数据库

; a9 u; E) V$ k, d9 p[root@zabbix-server conf]# mysql -uzabbix -p
mysql: [Warning] Using a password on the command line interface can be insecure.
3 I- ]0 @5 L( a) ]Welcome to the MySQL monitor.  Commands end with ; or \g.
0 r" t1 V% O( C& E5 r2 y" uYour MySQL connection id is 50
$ e3 P1 w* N1 E& \Server version: 8.0.40 MySQL Community Server - GPL

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
! b8 R) x' W! d! U% baffiliates. Other names may be trademarks of their respective
$ H! J5 n* t$ T+ Uowners.
* I* d) d, o2 ?! F; D7 q
2 Y3 t/ Q) V' ^Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
' y: T2 A9 Z% L4 O6 o3 z
mysql> show databases;
! U% n" @6 B, g% p  V2 o1 k3 q+ k% G+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
3 {8 h. p  }6 i9 a# e' u| zabbix             |
+--------------------+
3 rows in set (0.01 sec)
, n& ~0 J  W9 J& d
" k' G$ E5 \% h6 k+ Amysql> use zabbix
, ~* [( v4 M* d8 tReading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

$ ^  E# L8 k! f& x+ r. LDatabase changed


$ y% ^4 |. S/ j1 m2 g
9 L! W1 [; F9 p- F  B: U1 Zmysql> select userid,username,name,passwd from users;
" M4 `/ M) u+ Y3 V% _7 C6 h+--------+----------+--------+--------------------------------------------------------------+
5 b9 A" y3 C- W| userid | username | name   | passwd                                                       |
+--------+----------+--------+--------------------------------------------------------------+
|      1 | Admin    | Zabbix | $2y$10$92nDno4n0Zm7Ej7Jfsz8WukBfgSS/U0QkIuu8WkJPihXBb2A1UrEK |
3 I9 f7 |  V3 ~0 q6 |/ b|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
+--------+----------+--------+--------------------------------------------------------------+
% e* |' i5 n' l( V. B2 y' }2 rows in set (0.00 sec)
3 J2 Q+ V* P0 h" O2 |# e
mysql> update users set passwd=MD5('victors123') where username='admin';
6 J- ]. A; [' d: W# C' cQuery OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0
5 N8 v0 |1 y( n" s! {
4 g; A# Q- X* y7 X% ]) |, a
8 a1 Y' {  B9 t" {9 l

admin

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

mysql> flush privileges;
1 c- c6 \+ y2 RQuery OK, 0 rows affected (0.02 sec)
; Y; ^7 L: X, {4 {( ~
mysql> select userid,username,name,passwd from users;
8 c1 g8 Z7 y$ [& p, o, ?+ x" e+--------+----------+--------+--------------------------------------------------------------+
. p6 Y' X, K3 ?7 h  O6 X| userid | username | name   | passwd                                                       |
+--------+----------+--------+--------------------------------------------------------------+
|      1 | Admin    | Zabbix | f82d61a5bae93646df737371905f8d20                             |
|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
) g5 S  w' O. v. c  ~3 o2 M; l+--------+----------+--------+--------------------------------------------------------------+
2 rows in set (0.00 sec)
* J: x1 i- N. i3 b% H  W

admin

echo -n admin |openssl md5
* F9 J) Q) e- ](stdin)= 21232f297a57a5a743894a0e4a801fc3

# }2 T2 h. `2 Y* }1 U8 K0 lmysql> update users set passwd='21232f297a57a5a743894a0e4a801fc3' where userid='1';
% W9 N3 b( I' z1 I; gQuery OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
1 O8 A7 w8 X# i% `. g2 ^, s
4 W0 N4 Z0 g/ y, C2 ]  [mysql> flush privileges;
2 z8 z: P  F9 }+ u' vQuery OK, 0 rows affected (0.02 sec)

! Q+ \* ^& c- n9 r6 ?! I( `# V