Zabbix Forgot login Password

A lot of small partners because of too many passwords, or due to the failure of the test machine to forget the password, the following method is expected to solve the problem of small partners.

1. Log in to the database first, select the Zabbix database, and view the Admin user.

Mysql> use zabbixreading table information for completion of table  and column namesyou can turn off this feature to get a  quicker startup with -ADatabase changedmysql> select * from  users\g*************************** 1. row ***************************         userid: 1         alias: admin           name: Zabbix        surname: Administrator        passwd:  e2798af12a7a0f4f70b4d69efbc25f4d           url:       autologin: 1    autologout: 0           lang: en_us       refresh: 30           type: 3         theme:  defaultattempt_failed: 0    attempt_ip: 210.51.19.2 attempt_clock:  1421286613 rows_per_page: 50

From the query results you can see that the admin password is a string of encrypted MD5 value, because we just need to replace the MD5 value.

2. Generate a MD5 value for a string.

Echo-n Redhat|openssl MD5 (stdin) = e2798af12a7a0f4f70b4d69efbc25f4d

Adding the-n parameter here is a guaranteed value unique

3. Replace the password of admin

Mysql> Update users set passwd= ' e2798af12a7a0f4f70b4d69efbc25f4d ' where userid= ' 1 '; Query OK, 1 row affected (0.01 sec) Rows matched:1 changed:1 warnings:0

4. Login Test

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/A4/wKioL1S3IcuDyDyYAAFgC5hHcG4705.jpg "title=" 1.png " alt= "Wkiol1s3icudydyyaafgc5hhcg4705.jpg"/>

5. The modification is complete.

The method above is implemented by updating the database.

This article is from "Alan Wake" blog, please make sure to keep this source http://alanwake.blog.51cto.com/6881848/1604165

Zabbix Forgot login Password