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: 1 Changed: 1 Warnings: 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.登陆测试
也可用下面这种方法更新密码
[root@zhu2 ~]# echo -n "zabbix" | md5sum 5fce1b3e34b520afeffb37ce08c7cd66 - mysql> update users set passwd='5fce1b3e34b520afeffb37ce08c7cd66' where userid=1; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 #和第一种方法大同小异,
转载于:https://blog.51cto.com/zhujiangtao/1313950