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

How to use DCL to manage users and control permissions in MySQL

DCL (Data Control Language): Data control languag...

Introduction to basic concepts and technologies used in Web development

Today, this article introduces some basic concept...

Implementing CommonJS modularity in browsers without compilation/server

Table of contents introduction 1. What is one-cli...

Detailed deployment of docker+gitlab+gitlab-runner

environment Server: centos7 Client: window Deploy...

JS implementation of carousel example

This article shares the specific code of JS to im...

MySQL data types full analysis

Data Type: The basic rules that define what data ...

MyBatis dynamic SQL comprehensive explanation

Table of contents Preface Dynamic SQL 1. Take a l...

MySQL knowledge points for the second-level computer exam mysql alter command

Usage of alter command in mysql to edit table str...

The solution of html2canvas that pictures cannot be captured normally

question First, let me talk about the problem I e...

Vue2 implements provide inject to deliver responsiveness

1. Conventional writing in vue2 // The parent com...

A brief analysis of event bubbling and event capture in js

Table of contents 01-Event Bubbling 1.1- Introduc...

Example of adding and deleting range partitions in MySQL 5.5

introduce RANGE partitioning is based on a given ...