重置Zabbix密码的方法（一步到位）

[zhuxiaoshuai@zabbix-server ~]# mysql -uroot -pzhuxiaoshuai!@# # -u是用户名，-p后面是密码

MariaDB [mysql]> use zabbix;
MariaDB [zabbix]> show tables;
MariaDB [zabbix]> select * from users;
MariaDB [zabbix]> select userid,alias,passwd from users;

[zhuxiaoshuai@zabbix-server ~]# echo -n zhuxiaoshuai | openssl md5
(stdin)= cce78f045146e7dbb2c7d0df900dcfb3

MariaDB [zabbix]> update users set passwd='cce78f045146e7dbb2c7d0df900dcfb3' where userid = '1';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [zabbix]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)