-->
  • Recent Articles

    How To Reset Zabbix Admin Password?

     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


    How To Reset Zabbix Admin Password?


    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;


    How To Reset Zabbix Admin Password

    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.





    6 comments:

    1. hi, i've a error when i try the query:
      ERROR 1054 (42S22): Unknown column 'alias' in 'field list'
      maybe in zabbix 5.4 is change?
      thank you

      ReplyDelete
      Replies
      1. Hi Gabriele,
        Sorry , Could not get back to you on time. Completely missed this comment.

        Delete
    2. hi, i've a error when i try the query:
      ERROR 1054 (42S22): Unknown column 'alias' in 'field list'
      maybe in zabbix 5.4 is change?
      thank you

      ReplyDelete
    3. I bro!

      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)


      See you later!

      ReplyDelete
    4. it still didnt changed

      ReplyDelete