How To Reset Zabbix Admin Password?

To recover Zabbix Admin password you need to follow the following Steps.

1. Login to Zabbix MySQL/MariaDB Password.

Use the following command to login the MySQL/MariaDB server as root. Please provide the password for root user.

# mysql -uroot -p

2. After entering the password, use the following MySQL commands to reset the Zabbix Admin user password.

For Zabbix version < 5.4

mysql> use zabbix;

mysql> update zabbix.users set passwd=md5('zabbix') where alias='Admin';

mysql> flush privilages; 

mysql> quit;

You need to use this command for Zabbix version 5.4:

Error:
mysql> update zabbix.users set passwd=md5('zabbix') where alias='Admin';
ERROR 1054 (42S22): Unknown column 'alias' in 'where clause'

Solved:
mysql> update zabbix.users set passwd=md5('zabbix') where username='Admin';
Query OK, 1 row affected (0.00 sec)

You need to use this command for Zabbix version 6:

To change the admin password in Zabbix 6 with MySQL as the database, you can follow these steps:

1. Log in to the server where Zabbix is installed.

2. Open a command prompt or terminal and log in to the MySQL server as the root user or a user with sufficient privileges.

   ```

   mysql -u root -p

   ```

3. Enter the password for the MySQL root user when prompted.

4. Switch to the Zabbix database.

   ```

   use zabbix;

   ```

5. Update the password for the admin user.

   ```

update users set passwd=md5('new_password') where alias='Admin';

   Replace 'new_password' with the desired password for the admin user.

Updated:

 The md5 doesn't work anymore. The password is now encryped with bcrypt so run it through bcrypt first
Example: You can use web based tool too for bcrypt.

 htpasswd -bnBC 10 "zabbix" password | tr -d ':\n'

then in mysql, example:

syntax:

update zabbix.users set passwd=(' brcypt password')  where userid='1';

update zabbix.users set passwd=('$2y$10$zH.KFQELRDLKlExVq18Z.eVty9yLGL7cHM9B9vTuXX1oDTcWvYALK')  where userid='1';

   ```

6. Flush the privileges to ensure the changes take effect.

   ```

   flush privileges;

   ```

7. Exit the MySQL prompt.

   ```

   exit;

   ```

After following these steps, the admin password in Zabbix 6 should be changed to the new password you specified. Make sure to use a strong password to ensure the security of your Zabbix installation.

In our example, we changed the Admin user password to zabbix.

How to Add Host in Zabbix Server to Monitor

How to install Zabbix Agent on CentOS / RHEL 6/7

How to Install Zabbix 4.4 in RHEL/CentOS 7

How To Install Zabbix Agent on Ubuntu 18.04 16.04 LTS

How to Add Host in Zabbix Server to Monitor

How To Install Zabbix Agent on Ubuntu 18.04 16.04 LTS

How to Add MySQL/MariaDB to zabbix monitoring?

zabbix -- Delaying  sending alert e-mails?