mysql> use zabbixmysql> desc users;+----------------+---------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+----------------+---------------------+------+-----+---------+-------+| UserID | bigint (unsigned) | NO | PRI | NULL | || Alias | varchar (100) | NO | UNI | | || name | varchar (100) | NO | | | || Surname | varchar (100) | NO | | | || passwd | char (32) | NO | | | || URL | varchar (255) | NO | | | || Autologin | Int (11) | NO | | 0 | || Autologout | Int (11) | NO | | 900 | || Lang | varchar (5) | NO | | EN_GB | || Refresh | Int (11) | NO | | 30 | || Type | Int (11) | NO | | 1 | || Theme | varchar (128) | NO | | Default | || attempt_failed | Int (11) | NO | | 0 | || Attempt_ip | varchar (39) | NO | | | || Attempt_clock | Int (11) | NO | | 0 | || Rows_per_page | Int (11) | NO | | 50 | |+----------------+---------------------+------+-----+---------+-------+16 rows in Set (0.00 sec) mysql> Select USERID,ALIAS,PASSWD from users;+--------+-------+----------------------------------+| UserID | Alias | passwd |+--------+-------+----------------------------------+| 1 | Admin | a9289c3c21539e20fd6a060256e30b09 | | 2 | Guest | d41d8cd98f00b204e9800998ecf8427e |+--------+-------+----------------------------------+2 rows in Set (0.00 sec) MySQL > select userid,alias,passwd from users;+--------+-------+----------------------------------+| UserID | Alias | PassWD |+--------+-------+----------------------------------+| 1 | Admin | a9289c3c21539e20fd6a060256e30b09 | | 2 | Guest | d41d8cd98f00b204e9800998ecf8427e |+--------+-------+----------------------------------+2 rows in Set (0.00 sec) MySQL > Update users set PASSWD=MD5 (' 123456 ') where userid=1;#-------->md5 encrypted query OK, 1 row affected (0.04 sec) Rows Matche D:1 changed:1 warnings:0mysql> Select userid,alias,passwd from users;+--------+-------+-------------------------- --------+| UserID | Alias | passwd |+--------+-------+----------------------------------+| 1 | Admin | a9289c3c21539e20fd6a060256e30b09 | | 2 | Guest | d41d8cd98f00b204e9800998ecf8427e |+--------+-------+----------------------------------+2 rows in Set (0.00 sec) MySQL > Update users set PASSWD=MD5 (' 123456 ') where userid=1; Query OK, 1 row affected (0.04 sec) Rows matched:1 changed:1 warnings:0
Zabbix Modifying the Administrator user password