zabbix 创建mysql用户名密码_在数据库中改zabbix用户密码

mysql -uroot -p  # 进入数据库

use zabbix;   # 进入zabbix库

select * from users\G;   # 查看 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'; # 此处不能用 update users set passwd=password('123456') where userid='1'; zabbix没有这个方法.

flush privileges;# 刷新权限表