reset-admin-password-zabbix

MySQL/ MariaDB Database
If you installed Zabbix Server using MySQL or MariaDB you can easily use the following instructions :

– Logon to the MySQL or MariaDB database as below:

root@ylplzbx01:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
– Connect to the zabbix database

mysql> use YOUR_ZABBIX_DATABASE
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
– Change the password of the Admin Zabbix user to your new password:

mysql> update users set passwd=md5('YOUR_NEW_PASSWORD') where alias='Admin';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
– Logout from MySQL or MariaDB using the following command:

mysql> exit
Bye
root@ylplzbx01:~#
Postgresql Database
Use the following instructions if you installed Zabbix Server with postgreSQL database:

– Logon to the postgreSQL as below:

root@ylplzbx01:~# sudo -u postgres psql
– Connect to the zabbix database

\c YOUR_ZABBIX_DATABASE
– Change the password of the Admin Zabbix user with a your new password:

update users set passwd=md5('YOUR_NEW_PASSWORD') where alias='Admin';
– Finally logout from postgreSQL using the following command

\q

 
We hope this tutorial was enough Helpful. If you need more information, or have any questions, just comment below and we will be glad to assist you!