Zabbix login Account Admin Password change

Source: Internet
Author: User
Tags openssl md5

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.