1.查看数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| zabbix |
+--------------------+
5 rows in set (0.00 sec)2.进入数据库
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 changed3.查看是否存放用户、密码信息
mysql> select * from users;4.更新zabbix用户密码
mysql> update users set passwd=md5("YouPasswd") where userid='1';
Query OK, 0 rows affected (0.01 sec)
Rows matched: 1 Changed: 0 Warnings: 0
1 个回复
koyo - 网站管理 致力做全栈工程师 爱ui 爱前端
赞同来自: Ansible
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| zabbix |
+--------------------+
5 rows in set (0.00 sec)2.进入数据库
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 changed3.查看是否存放用户、密码信息
mysql> select * from users;4.更新zabbix用户密码
mysql> update users set passwd=md5("YouPasswd") where userid='1';
Query OK, 0 rows affected (0.01 sec)
Rows matched: 1 Changed: 0 Warnings: 0