忘记密码zabbix

忘记了zabbix密码怎么办？

  首先去查看mysql数据库

 

  查看数据库

   mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| zabbix             | 
+--------------------+
5 rows in set (0.00 sec)

 

进入数据库
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;


查看是否存放用户、密码信息


mysql> select * from users;


更改密码为zabbix
mysql> update  users set passwd=md5("zabbix") where userid='1';
Query OK, 0 rows affected (0.01 sec)
Rows matched: 1  Changed: 0  Warnings: 0