zabbix 创建mysql用户名密码_zabbix 修改用户登录密码（解锁也可用此方法）

首先去看看mysql数据库

查看数据库

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| zabbix             |

+--------------------+

5 rows in set (0.00 sec)

进入数据库

mysql> use zabbix;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

查看数据有那些表

mysql> show tables;

查看是否存放用户、密码信息

mysql> select * from users;

更改密码为zabbix

mysql> update  users set passwd=md5("zabbix") where userid='1';

Query OK, 0 rows affected (0.01 sec)

Rows matched: 1  Changed: 0  Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)