zabbix登陆账户admin密码修改

zabbix的admin用户密码忘记了

登陆数据库

[root@ajpapi bin]# ./mysql -uroot -poneapm_si

mysql> use zabbix;

-- 查看表里的字段，admin对应的ID是1 
mysql> select * from users;
+--------+-------+--------+---------------+----------------------------------+-----+-----------+------------+-------+---------+------+---------+----------------+----------------+---------------+---------------+
| 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 | 30s     |    3 | default |              0 | 192.168.99.132 |    1515133784 |            50 |
|      2 | guest |        |               | d41d8cd98f00b204e9800998ecf8427e |     |         0 | 15m        | en_GB | 30s     |    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> quit

退出之后。生成一个MD5加密的密码，这里密码设置的是RedHat
-n就表示不输入回车符，不加-n，否则就不是这个结果了。

[root@ajpapi bin]# echo -n redhat|openssl md5
(stdin)= e2798af12a7a0f4f70b4d69efbc25f4d

[root@ajpapi bin]# ./mysql -uroot -poneapm_si
mysql> use zabbix;
mysql> update users set passwd='e2798af12a7a0f4f70b4d69efbc25f4d' where userid = '1';

mysql> flush privileges;

mysql> quit