March 2 2016

zabbix修改admin的密码

mysql> use zabbix
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

 

mysql> show tables;
+———————–+
| 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_text |
| history_uint |
| 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_condition |
| item_discovery |
| items |
| items_applications |
| maintenances |
| maintenances_groups |
| maintenances_hosts |
| maintenances_windows |
| mappings |
| media |
| media_type |
| 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_groups |
| usrgrp |
| valuemaps |
+———————–+
104 rows in set (0.00 sec)

 

 

mysql> select name,passwd from users;
+——–+———————————-+
| name | passwd |
+——–+———————————-+
| Zabbix | 5fce1b3e34b520afeffb37ce08c7cd66 |
| | d41d8cd98f00b204e9800998ecf8427e |
+——–+———————————-+

自己找个控制台去生成一个MD5加密的密码,这里密码设置的是ucjmh

 

[root@mysql ~]# echo -n ucjmh | openssl md5
(stdin)= 742dacc04e481b15392d8b8ccea4ffde

 

update users set  passwd=’742dacc04e481b15392d8b8ccea4ffde’ where userid = ‘1’;



Copyright 2019. All rights reserved.

Posted 2016年3月2日 by ucjmh in category "其它

Leave a Reply

Your email address will not be published. Required fields are marked *