How To Reset Zabbix Admin Password?
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.
mysql> use zabbix;
mysql> update zabbix.users set passwd=md5('zabbix') where alias='Admin';
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)
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 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
About Manas Ranjan Tripathy
hi, i've a error when i try the query:
ReplyDeleteERROR 1054 (42S22): Unknown column 'alias' in 'field list'
maybe in zabbix 5.4 is change?
thank you
Hi Gabriele,
DeleteSorry , Could not get back to you on time. Completely missed this comment.
hi, i've a error when i try the query:
ReplyDeleteERROR 1054 (42S22): Unknown column 'alias' in 'field list'
maybe in zabbix 5.4 is change?
thank you
I bro!
ReplyDeleteYou 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)
See you later!
Thanks bro
Delete