本文共 2171 字，大约阅读时间需要 7 分钟。

1:登陆数据库

[root@localhost ~]# mysql -uroot -p'passwd'

2：切换到zabbix数据库

MariaDB [(none)]> use zabbix;

3：查看users表结构

MariaDB [zabbix]> desc users;+----------------+---------------------+------+-----+---------+-------+| Field          | Type                | Null | Key | Default | Extra |+----------------+---------------------+------+-----+---------+-------+| userid         | bigint(20) 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     | varchar(32)         | NO   |     | 15m     |       || lang           | varchar(5)          | NO   |     | en_GB   |       || refresh        | varchar(32)         | NO   |     | 30s     |       || 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)

4:查看Admin的用户信息

MariaDB [zabbix]> select userid,alias,name,passwd from users where userid=1;+--------+-------+--------+----------------------------------+| userid | alias | name   | passwd                           |+--------+-------+--------+----------------------------------+|      1 | Admin | Zabbix | 202cb962ac59075b964b07152d234b70 |+--------+-------+--------+----------------------------------+1 row in set (0.00 sec)

5:更改Admin的用户密码

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

转载地址：http://wenwi.baihongyu.com/