Zabbix 监控之 修改管理员用户密码
zabbix监控中当一般用户的密码忘记了也不要紧，可以通过管理员用户admin很容易的创建一个用户，然而。当管理员的密码忘记了，这时只能在数据库里进行修改。zabbix前端用户的操作都保存在zabbix数据库的users表里
1.查看users表
mysql> desc users;
+----------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| userid | bigint(20) unsigned | NO | PRI | NULL | |
| alias | varchar(100) | NO | MUL | | |
| name | varchar(100) | NO | | | |
| surname | varchar(100) | NO | | | |
| passwd | char(32) | NO | | | |
| url | varchar(255) | NO | | | |
| autologin | int(11) | NO | | 0 | |
| autologout | int(11) | NO | | 900 | |
| lang | varchar(5) | NO | | en_GB | |
| refresh | int(11) | NO | | 30 | |
| type | int(11) | NO | | 0 | |
| theme | varchar(128) | NO | | default | |
| attempt_failed | int(11) | NO | | 0 | |
| attempt_ip | varchar(39) | NO | | | |
| attempt_clock| int(11) | NO | | 0 | |
| rows_per_page| int(11) | NO | | 50 | |
+----------------+---------------------+------+-----+---------+-------+
16 rows in set (0.00 sec)
mysql> select userid,name,passwd from users;
+--------+----------+----------------------------------+
| userid | name | passwd |
+--------+----------+----------------------------------+
| 1 | Zabbix | 5fce1b3e34b520afeffb37ce08c7cd66 |
| 2 | Default| d41d8cd98f00b204e9800998ecf8427e |
| 3 | jiangtao | e10adc3949ba59abbe56e057f20f883e |
+--------+----------+----------------------------------+
3 rows in set (0.00 sec) 2.修改admin用户的密码
mysql> select userid,alias,passwd from users; #查看
+--------+-------------+----------------------------------+
| userid | alias | passwd |
+--------+-------------+----------------------------------+
| 1 | Admin | 5fce1b3e34b520afeffb37ce08c7cd66 |
| 2 | guest | d41d8cd98f00b204e9800998ecf8427e |
| 3 | zhujiangtao | e10adc3949ba59abbe56e057f20f883e |
+--------+-------------+----------------------------------+
3 rows in set (0.00 sec)
mysql> update users set passwd=MD5('zhuzhu') where userid=1; #修改
Query OK, 1 row affected (0.01 sec)
Rows matched: 1Changed: 1Warnings: 0
mysql> select userid,alias,passwd from users;
+--------+-------------+----------------------------------+
| userid | alias | passwd |
+--------+-------------+----------------------------------+
| 1 | Admin | 8f1fa88773e0518f7446972f1ed74ab5 |
| 2 | guest | d41d8cd98f00b204e9800998ecf8427e |
| 3 | zhujiangtao | e10adc3949ba59abbe56e057f20f883e |
+--------+-------------+----------------------------------+
3 rows in set (0.00 sec)
mysql> flush privileges;#刷新权限
Query OK, 0 rows affected (0.01 sec) 3.登陆测试
http://blog.运维网.com/attachment/201310/150138626.jpg
也可用下面这种方法更新密码
# echo -n "zabbix" | md5sum
5fce1b3e34b520afeffb37ce08c7cd66-
mysql> update users set passwd='5fce1b3e34b520afeffb37ce08c7cd66'where userid=1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1Changed: 1Warnings: 0
#和第一种方法大同小异，
页:
[1]