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

Vue realizes the product magnifying glass effect

This article example shares the specific code of ...

JavaScript to achieve full screen page scrolling effect

After I finished reading JavaScript DOM, I had a ...

Summary of the application of decorative elements in web design

<br />Preface: Before reading this tutorial,...

Beginner's guide to building a website ⑥: Detailed usage of FlashFXP

Today I will introduce the most basic functions of...

Summary of common sql statements in Mysql

1. mysql export file: SELECT `pe2e_user_to_compan...

How to cancel the background color of the a tag when it is clicked in H5

1. Cancel the blue color of the a tag when it is ...

An example of how to quickly deploy web applications using Tomcat in Docker

After learning the basic operations of Docker, we...

JavaScript clicks the button to generate a 4-digit random verification code

This article example shares the specific code of ...

Html+css to achieve pure text and buttons with icons

This article summarizes the implementation method...

Pagination Examples and Good Practices

<br />Structure and hierarchy reduce complex...

Detailed explanation of the use of redux in native WeChat applet development

premise In complex scenarios, a lot of data needs...