未修改之前(忘记登录密码)
[root@abcdocker ~]# mysql -uroot -p -e "select * from zabbix.users\G"
Enter password:
MariaDB [zabbix]> select * from users\G;
*************************** 1. row ***************************
userid: 1
alias: wuyutang0219
name: Zabbix
surname: Administrator
passwd: 5c3dc819f6f5eb10078752ddc69f6619
url:
autologin: 1
autologout: 0
lang: en_US
refresh: 30s
type: 3
theme: default
attempt_failed: 0
attempt_ip: 124.160.36.242
attempt_clock: 1540863101
rows_per_page: 50
登录MySQL 修改密码
[root@abcdocker ~]# mysql -uroot -p
由于密码是md5加密的，我们可以查看默认的zabbix密码的md5
mysql> use zabbix;
mysql> update users set passwd='5fce1b3e34b520afeffb37ce08c7cd66' where userid='1';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
解释：5fce1b3e34b520afeffb37ce08c7cd66 = zabbix
因为zabbix默认密码就是zabbix