一、正常更改用户密码
管理-用户-右侧选择“用户”-点击列表里的Admin-点击修改密码-输入新密码后点击存档
二、忘记密码,重置密码
如果忘记了zabbix的登陆账户admin密码,可以通过以下方式找回:
[root@localhost ~]# 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数据库Database changedmysql> show tables; #再查看一下里面有很多张表,admin密码放在users表里面。+-----------------------+| 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 || p_w_picpaths || 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; # 查看表里的字段,admin对应的ID是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>
重新开个终端,生成一个MD5加密的密码,这里密码设置的是redhat
[root@localhost ~]# echo -n redhat|openssl md5 #-n就表示不输入回车符,不加-n,否则就不是这个结果了。(stdin)= e2798af12a7a0f4f70b4d69efbc25f4d[root@localhost ~]#
接着上面的为admin用户设定一个密码
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[root@localhost ~]#
刷新页面使用admin redhat登陆即可