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

admin

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

首先登录数据库
1 p/ {% G3 _! d
[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
' W2 v3 V! e3 c1 z& K5 `Server version: 8.0.40 MySQL Community Server - GPL

0 k1 s- k2 J" G& v# F8 |) tCopyright (c) 2000, 2024, Oracle and/or its affiliates.
  [8 e; b3 Z8 B) H  S0 d
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
: t6 v" C( D9 [: c3 S! ?; e
mysql> show databases;
/ T  U' Y' z" a/ s: E% p: j+--------------------+
- U$ |; U9 }$ q| Database           |
+--------------------+
| information_schema |
| performance_schema |
| zabbix             |
+ _' Q6 _4 G' M& t1 j0 @5 L+--------------------+
8 M7 R: ?- B# b7 F8 H0 V3 rows in set (0.01 sec)
. w" R& U' Y9 |- p( P0 {: @' P
mysql> use zabbix
Reading table information for completion of table and column names
( l* }2 K3 F7 k( A/ ]3 nYou can turn off this feature to get a quicker startup with -A

- Z) j; A* V$ g2 b# E9 IDatabase changed
0 F) E' l( S5 z6 ^+ H5 E/ \
0 t/ j; q' U, I3 X6 k
: g8 I5 ?& G5 ]& o. H
mysql> select userid,username,name,passwd from users;
+--------+----------+--------+--------------------------------------------------------------+
| userid | username | name   | passwd                                                       |
+--------+----------+--------+--------------------------------------------------------------+
0 X( P6 g# r5 z2 s|      1 | Admin    | Zabbix | $2y$10$92nDno4n0Zm7Ej7Jfsz8WukBfgSS/U0QkIuu8WkJPihXBb2A1UrEK |
|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
2 \) U" Z* t% a5 E+--------+----------+--------+--------------------------------------------------------------+
% X& a$ R; u6 L5 g" [* t2 rows in set (0.00 sec)

mysql> update users set passwd=MD5('victors123') where username='admin';
Query OK, 0 rows affected (0.00 sec)
/ U/ N1 T# `/ |& x3 WRows matched: 0  Changed: 0  Warnings: 0
4 ~1 {+ [- O/ f5 A) d- A
$ X- w8 ~/ E8 C3 E$ m( N/ o7 Q% I

( w- ^1 Q$ D5 Q4 i+ L; @: I& ]: G' [
& j: i9 ?* L) [: u

admin

mysql> update users set passwd=MD5('victors123') where username='Admin';
Query OK, 1 row affected (0.00 sec)
6 P% P( E3 U$ W$ iRows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)

. h$ X" E( _. h* e% B$ Pmysql> select userid,username,name,passwd from users;
+--------+----------+--------+--------------------------------------------------------------+
; ^( i, O' P" T| userid | username | name   | passwd                                                       |
+ \1 N7 o* ~$ g( m+--------+----------+--------+--------------------------------------------------------------+
/ B6 e6 h# n( t" K|      1 | Admin    | Zabbix | f82d61a5bae93646df737371905f8d20                             |
6 Z5 t4 u3 N7 _. _|      2 | guest    |        | $2y$10$89otZrRNmde97rIyzclecuk6LwKAsHN0BcvoOKGjbT.BwMBfm7G06 |
% f; }1 }# E$ B* c+--------+----------+--------+--------------------------------------------------------------+
9 a' K* V' g2 C. w2 @2 rows in set (0.00 sec)
- `3 H9 P5 k' T  G7 L) _: C$ F
' e. V' x9 \& k% Z% M

admin

echo -n admin |openssl md5
  F# n: s. a# R4 f; }/ U(stdin)= 21232f297a57a5a743894a0e4a801fc3

mysql> update users set passwd='21232f297a57a5a743894a0e4a801fc3' where userid='1';
Query OK, 1 row affected (0.00 sec)
  E& |( F  m5 x3 TRows matched: 1  Changed: 1  Warnings: 0

8 X# g5 u3 o& w* E0 H# Ymysql> flush privileges;
2 s% b$ D( d0 ]2 \Query OK, 0 rows affected (0.02 sec)
* H+ t: Z! r( }" H. X. Z) r
% ^! k8 F7 k2 s8 R  k; J