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

admin

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

/ g% O. P! Y% o# r# C# m+ B首先登录数据库
0 [+ k  X7 R# q- H) X
, J/ ?. z6 x6 v2 Z+ Z1 A( p[root@zabbix-server conf]# mysql -uzabbix -p
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 50
! v) r: G3 v8 Z" j0 V5 O* qServer version: 8.0.40 MySQL Community Server - GPL
) e0 |( }  n7 {$ t7 \+ {
Copyright (c) 2000, 2024, Oracle and/or its affiliates.
- T: K( o+ t# y: e* K. t
  O2 B' P4 e  t+ t* gOracle is a registered trademark of Oracle Corporation and/or its
7 \+ P0 H1 p/ I4 Raffiliates. Other names may be trademarks of their respective
1 P* Q& Z; d# vowners.
$ H8 [* j4 c0 g/ }( P% L. z
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
- z) ~# a2 j* b2 B( y7 j4 _2 }  o+--------------------+
| Database           |
$ r1 M# R( ?( q3 ]0 z& y3 t+--------------------+
| information_schema |
/ ?' P) u. E% x8 `! N| performance_schema |
| zabbix             |
* G9 I0 j2 e' w& k) V& v0 \) p+--------------------+
3 rows in set (0.01 sec)

mysql> use zabbix
Reading table information for completion of table and column names
2 r7 m5 s; ~, B' R6 X/ K5 zYou can turn off this feature to get a quicker startup with -A
; L5 y: K$ u. u
Database changed

$ f- A* t" I7 e" q( i4 p
/ T; N1 g4 I' F$ P( d/ w8 p$ q3 {
mysql> select userid,username,name,passwd from users;
+--------+----------+--------+--------------------------------------------------------------+
% r6 k* W2 a( [  M  J! v( Q6 B. H, C; d| userid | username | name   | passwd                                                       |
2 t* y7 C, k) H$ w( q+ ?+--------+----------+--------+--------------------------------------------------------------+
|      1 | Admin    | Zabbix | $2y$10$92nDno4n0Zm7Ej7Jfsz8WukBfgSS/U0QkIuu8WkJPihXBb2A1UrEK |
|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
+--------+----------+--------+--------------------------------------------------------------+
2 rows in set (0.00 sec)

2 V: D& ^6 x; H# m$ T) Vmysql> update users set passwd=MD5('victors123') where username='admin';
1 i2 `! N: z0 S5 O/ iQuery OK, 0 rows affected (0.00 sec)
% F( p1 S, R5 c8 }3 X2 h& x% _Rows matched: 0  Changed: 0  Warnings: 0
! |" @7 r3 e5 z, X2 m2 |
$ h( i5 }1 x  O- f% k. w$ M


0 ?, G( r' C7 i: Y. }/ r/ K* q

admin

mysql> update users set passwd=MD5('victors123') where username='Admin';
5 Y) h! u" v% |Query 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)

mysql> select userid,username,name,passwd from users;
) g0 o' A, j; ?3 T4 \0 u+--------+----------+--------+--------------------------------------------------------------+
| userid | username | name   | passwd                                                       |
+--------+----------+--------+--------------------------------------------------------------+
, s7 v3 c8 `+ ]" R/ P8 i|      1 | Admin    | Zabbix | f82d61a5bae93646df737371905f8d20                             |
8 b8 U. \/ I7 x  P. i|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
( S- r+ e( ]- }* G: L& F* p+--------+----------+--------+--------------------------------------------------------------+
' P' Q1 |3 @  |8 A! q% e; b5 R) R; F2 rows in set (0.00 sec)

" ]% ^8 P3 v( N9 S

admin

echo -n admin |openssl md5
6 F9 b" ~. ?5 D0 ^# W(stdin)= 21232f297a57a5a743894a0e4a801fc3

: f4 g5 t$ m# K, Jmysql> update users set passwd='21232f297a57a5a743894a0e4a801fc3' where userid='1';
. e  s+ f- \3 n" Q$ gQuery OK, 1 row affected (0.00 sec)
1 C+ F# [2 A  l- RRows matched: 1  Changed: 1  Warnings: 0
5 G* c0 e8 d" r  a( q4 d- ~# L  h+ A
% ~8 Y/ a& n, {8 _3 q6 Omysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)

" k2 I. ^# b8 Q/ p8 K