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

 

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)