Zabbix forgot password, reset password

First look at the MySQL database.

View Database

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

Enter the database
mysql> use Zabbix;
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a
Database changed

View data with those tables

Mysql> Show tables;

See if the user, password information is stored

Mysql> select * from users;

Change Password to 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