Change the Zabbix user password in the database

Mysql-uroot-p # entering the database

Use Zabbix; # Enter the Zabbix library

SELECT * from Users\g; # view UserID

1. Row ***************************

Userid:1

Alias:admin

Name:zabbix

Surname:administrator

Passwd:21232f297a57a5a743894a0e4a801fc3

Url:

Autologin:1

autologout:0

Lang:zh_cn

Refresh:30

Type:3

Theme:default

attempt_failed:0

attempt_ip:192.168.1.222

attempt_clock:1517301067

Rows_per_page:50

Update users set PASSWD=MD5 (' 123456 ') where userid= ' 1 '; # cannot be used here with Update users set Passwd=password (' 123456 ') where userid= ' 1 '; Zabbix does not have this method.

Flush privileges; # Refresh Permissions Table

Change the Zabbix user password in the database