Shulou(Shulou.com)06/02 Report--

This article focuses on "how to solve the problem that Zabbix forgot the admin login password". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to solve the problem that Zabbix forgot your admin login password".

The details are as follows:

1. Problem description:

two。 Solve the problem

2.1 zabbix connects to the mysql database

[root@zabbix] # mysqlWelcome to the MariaDB monitor. Commands end with; or\ g.Your MariaDB connection id is 52Server version: 5.5.65-MariaDB MariaDB ServerCopyright (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 query the users table after entering the mysql database

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.4Then update table data, this user of userid=1

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

2.5 Refresh reload permissions table

MariaDB [zabbix] > FLUSH PRIVILEGES;Query OK, 0 rows affected (0.00 sec) 3. Just log in again.

At this point, I believe you have a deeper understanding of "how to solve the problem that Zabbix forgot your admin login password". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.