One, the normal change user password
Manage-users-select "Users" on the right-click on the admin-in the list to edit the password-click on the archive after entering the new password
650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/79/87/wKioL1aT2wDyoINeAACUObHs5mg603.png "style=" float: none; "title=" 36020160112003543833.png "alt=" Wkiol1at2wdyoineaacuobhs5mg603.png "/>
650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/79/88/wKiom1aT2tGSwCQxAABp1mqY8Fo319.png "style=" float: none; "title=" 36020160112003700855.png "alt=" Wkiom1at2tgswcqxaabp1mqy8fo319.png "/>
650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/79/87/wKioL1aT2wChFgAzAABSY2u4H_Y372.png "style=" float: none; "title=" 36020160112003745444.png "alt=" Wkiol1at2wchfgazaabsy2u4h_y372.png "/>
Second, forget password, reset password
If you forget the login admin password for Zabbix, you can get it back by the following way:
[[email protected] ~]# mysql -uroot -p #登陆数据库Enter password: welcome to the mysql monitor. commands end with ; or \g.mysql> show databases; #查询当前所有的库 +--------------------+| database |+--------------------+| information_schema | | mysql | | performance_schema | | zabbix |+------------------ --+4 rows in set (0.02 sec) mysql> use zabbix; #进入zabbix数According to the library database changedmysql> show tables; #再查看一下里面有很多张表, the admin password is placed in the Users table. +-----------------------+| tables_in_zabbix |+-----------------------+ | acknowledges | | actions | | alerts | | application_template | | applications | | auditlog | | auditlog_details | | autoreg_host | | conditions | | config | | dbversion | | dchecks | | dhosts | | drules | | dservices | | escalations | | events | | expressions | | functions | | globalmacro | | globalvars | | graph_discovery | | graph_theme | | graphs | | graphs_items | | group_discovery | | group_prototype | | groups | | history | | history_log | | history_str | | history_str_sync | | history_sync | | history_text | | history_uint | | history_uint_sync | | host_discovery | | host_inventory | | hostmacro | | hosts | | hosts_groups | | hosts_templates | | housekeeper | | httpstep | | httpstepitem | | httptest | | httptestitem | | icon_map | | icon_mapping | | ids | | images | | interface | | interface_discovery | | item_discovery | | items | | items_applications | | maintenances | | maintenances_groups | | maintenances_hosts | | maintenances_windows | | mappings | | media | | media_type | | node_cksum | | nodes | | opcommand | | opcommand_grp | | opcommand_hst | | opconditions | | operations | | opgroup | | opmessage | | opmessage_grp | | opmessage_usr | | optemplate | | profiles | | proxy_autoreg_host | | proxy_dhistory | | proxy_history | | regexps | | rights | | screens | | screens_items | | scripts | | service_alarms | | services | | services_links | | services_times | | sessions | | slides | | slideshows | | sysmap_element_url | | sysmap_url | | sysmaps | | sysmaps_elements | | sysmaps_link_triggers | | sysmaps_links | | timeperiods | | trends | | trends_uint | | trigger_depends | | trigger_discovery | | triggers | | user_history | | users | #users表 | users_groups | | usrgrp | | valuemaps |+--------------- --------+108 rows in set (0.00 sec) mysql> select * from users; # View the field in the table, the admin ID is 1+--------+-------+--------+-------------- -+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+------------+---------------+---------------+| userid | alias | name | surname | passwd | url | autologin | autologout | lang | refresh | type | theme | attempt_failed | attempt_ip | attempt_clock | rows_per_page |+--------+-------+--------+-------- -------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+-- --------------+------------+---------------+---------------+| 1 | admin | zabbix | administrator | 5fce1b3e34b520afeffb37ce08c7cd66 | | 1 | 0 | zh_CN | 30 | 3 | default | 0 | | 0 | 50 | | 2 | guest | | | d41d8cd98f00b204e9800998ecf8427e | | 0 | 900 | en_gb | 30 | 1 | default | 0 | | 0 | 50 |+-------- +-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+--- ------+------+---------+----------------+------------+---------------+---------------+2 rows in set (0.00 sec) mysql> select userid,passwd from users;+--------+-------- --------------------------+| userid | passwd |+--------+----------------------------------+| 1 | 5fce1b3e34b520afeffb37ce08c7cd66 | #密码是加密的 | 2 | d41d8cd98f00b204e9800998ecf8427e |+--------+----------------------------------+2 rows in set (0.00 sec) mysql>
To open the end again end, generate a MD5 encrypted password, where the password is set to Redhat
[Email protected] ~]# echo-n redhat|openssl MD5 (stdin) = E2798af12a7a0f4f70b4d69efbc25f4d[[email protected] ~]#
Then the above for the Admin user set a password
Mysql> Update users set passwd= ' e2798af12a7a0f4f70b4d69efbc25f4d ' where UserID = ' 1 '; #或者直接使用update Users set PASSWD=MD5 ("Redhat") where userid= ' 1 '; Query OK, 1 row affected (0.01 sec) Rows matched:1 changed:1 warnings:0mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> Quitbye[[email protected] ~]#
Refresh page using admin redhat Login
This article is from "I am not a rookie" blog, please be sure to keep this source http://pvbutler.blog.51cto.com/7662323/1734003
Zabbix login Account Admin Password change