ZABBIX忘记登录密码重置方法

未修改之前(忘记登录密码)

[root@abcdocker ~]# mysql -uroot -p -e “select * from zabbix.users\G”

Enter password:

MariaDB [zabbix]> select * from users\G;

*************************** 1. row ***************************

userid: 1

alias: wuyutang0219

name: Zabbix

surname: Administrator

passwd: 5c3dc819f6f5eb10078752ddc69f6619

url:

autologin: 1

autologout: 0

lang: en_US

refresh: 30s

type: 3

theme: default

attempt_failed: 0

attempt_ip: 124.160.36.242

attempt_clock: 1540863101

rows_per_page: 50

 

登录MySQL 修改密码

[root@abcdocker ~]# mysql -uroot -p

由于密码是md5加密的,我们可以查看默认的zabbix密码的md5

mysql> use zabbix;

mysql> update users set passwd=’5fce1b3e34b520afeffb37ce08c7cd66′ where userid=’1′;

Query OK, 1 row affected (0.01 sec)

Rows matched: 1  Changed: 1  Warnings: 0

解释:5fce1b3e34b520afeffb37ce08c7cd66  = zabbix

因为zabbix默认密码就是zabbix