About Zabbix forget admin login password reset password

About Zabbix forget admin login password reset password

The problem of resetting the password for Zabbix admin login password is as follows:

1. Problem description:

2. Problem Solving

2.1 Zabbix connects to the MySQL database

[root@zabbix ~]#mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 52
Server version: 5.5.65-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

2.2 After entering the MySQL database, query the users table

MariaDB [zabbix]> use zabbix;
MariaDB [zabbix]> select userid,alias,passwd from users;
+--------+-------+----------------------------------+
| userid | alias | passwd |
+--------+-------+----------------------------------+
| 1 | Admin | a8105204604a0b11e916f3879aae3b0b |
| 2 | guest | d41d8cd98f00b204e9800998ecf8427e |
+--------+-------+----------------------------------+
2 rows in set (0.00 sec)

2.3 Generate a new password MD5, admin is the password

[root@zabbix ~]# echo -n admin | openssl md5
(stdin) = 21232f297a57a5a743894a0e4a801fc3

2.4 Then update the table data, the user with userid=1

MariaDB [zabbix]> update users set passwd='21232f297a57a5a743894a0e4a801fc3' where userid = '1';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

2.5 Refresh and reload the permission table

MariaDB [zabbix]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

3. Log in again

This is the end of this article about resetting the Zabbix admin login password. For more information about Zabbix admin password, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • Zabbix SAML SSO Login Bypass Vulnerability Operational Flow

<<:  Example code for implementing a text marquee with CSS3

>>:  Various front-end printing methods of web: CSS controls web page printing style

Recommend

Design a data collector with vue

Table of contents Scenario Core Issues Status mon...

Discussion on Web Imitation and Plagiarism

A few months after entering the industry in 2005, ...

How to deploy services in Windows Server 2016 (Graphic Tutorial)

introduction Sometimes, if there are a large numb...

Linux RabbitMQ cluster construction process diagram

1. Overall steps At the beginning, we introduced ...

Linux hardware configuration command example

Hardware View Commands system # uname -a # View k...

The new version of Chrome browser settings allows cross-domain implementation

Preface Currently, the front-end solves cross-dom...

N ways to align the last row of lists in CSS flex layout to the left (summary)

I would like to quote an article by Zhang Xinxu a...

Docker /var/lib/docker/aufs/mnt directory cleaning method

The company's service uses docker, and the di...

Introduction to html form control disabled attributes readonly VS disabled

There are two ways to disable form submission in ...

Embedded transplant docker error problem (summary)

After a long period of transplantation and inform...

How to enable TLS and CA authentication in Docker

Table of contents 1. Generate a certificate 2. En...