ZABBIX Forgot login Password

ZABBIX forgot login password

tags (space delimited): Zabbix

Just blowing up in the group, because of more accounts, the brain easy watt. Results Forget your Zabbix login password below is the example of retrieving login password

Before modification (forgot login password)

[Root@abcdocker ~]# mysql-uroot-p-E "select * from Zabbix.users\g"
Enter password: 
******** 1. Row ***************************
        userid:1
         alias:admin
          Name:zabbix
       surname:administrator
        passwd:ab66b6e18854fa4d45499d0a04a47b64
           URL: 
     autologin:1
    autologout:0
          lang:en_gb
       refresh:30
          type:3
         theme:default
attempt_failed:0
    attempt_ip:14.130.112.2
 attempt_ clock:1501141026
 rows_per_page:50

login MySQL Change password

[Root@abcdocker ~]# mysql-uroot-p
because the password is MD5 encrypted, we can view the default Zabbix password 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

Explanation: 5fce1b3e34b520afeffb37ce08c7cd66  = Zabbix
because Zabbix default password is Zabbix

Sign in to the Web
User name: Admin
Password: Zabbix

Tip: Please change your password immediately.

Finish.