CSAP-X超融合态势感知一体机（admin账户）密码忘记如何修改

CSAP-X超融合态势感知一体机（admin账户）密码忘记

无

[root@cyber ~]# mysql -p                 //进入mysql

Enter password: csap_starfox_h3c     //密码（实际操作时不会显示出来）

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 22650529

Server version: 5.7.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use cybersa_db;                     //切换数据库

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> update tbl_user set password='0ED64B109AACD3A3ACAA397B7C17A704' where name='admin';       //将admin密码重置为“admin@admin”

Query OK, 1 row affected (0.00 sec)

Rows matched: 1  Changed: 1  Warnings: 0

mysql> select user_id,name,password from tbl_user;            //查看系统用户信息

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

| user_id | name        | password                         |

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

|       1 | sysAdmin    | C62A1DA7983561372733429BDAF9885A |

|       2 | buzAdmin    | 348083E865F42F7BE8F072530A2B6F83 |

|       3 | admin       | 0ED64B109AACD3A3ACAA397B7C17A704 |

|       4 | auditAdmin  | 348083E865F42F7BE8F072530A2B6F83 |

|       5 | lpsyc-admin | 6E9EBDE36B857ACADC955F14C14CB869 |

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

5 rows in set (0.00 sec)

mysql> select * from tbl_user;               //查看账户信息

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

| user_id | name        | tenant_id | full_name     | portal_type | password                         | role_id | description | create_time         | login_time | last_time | pwd_change_time     | fail_count | is_lock | group_id | theme_id | tel  | email | update_time         | fail_lock_time      | add_mode |

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

|       1 | sysAdmin    |         0 | systemAdmin   |           0 | C62A1DA7983561372733429BDAF9885A |       1 | NULL        | 2018-05-07 14:05:26 | NULL       | NULL      | 2022-07-21 21:43:51 |          0 |       0 |     NULL |        2 | NULL | NULL  | 2018-05-07 14:16:43 | NULL                |        0 |

|       2 | buzAdmin    |         0 | businessAdmin |           0 | 348083E865F42F7BE8F072530A2B6F83 |       2 | NULL        | 2018-05-07 14:04:40 | NULL       | NULL      | 2023-12-04 10:40:26 |          0 |       0 |     NULL |        2 | NULL | NULL  | 2018-05-07 14:10:37 | NULL                |        0 |

|       3 | admin       |         0 | admin         |           0 | 0ED64B109AACD3A3ACAA397B7C17A704 |       3 | NULL        | 2018-05-07 13:58:28 | NULL       | NULL      | 2023-11-30 15:55:41 |          2 |       0 |     NULL |        2 |      |       | 2023-05-30 10:44:12 | 2023-02-17 17:11:33 |        0 |

|       4 | auditAdmin  |         0 | AuditAdmin    |           0 | 348083E865F42F7BE8F072530A2B6F83 |       4 | NULL        | 2018-05-07 14:05:39 | NULL       | NULL      | 2023-12-04 10:37:08 |          0 |       0 |     NULL |        2 | NULL | NULL  | 2018-05-07 14:11:10 | NULL                |        0 |

|       5 | lpsyc-admin |         0 | lpsyc-admin   |           0 | 6E9EBDE36B857ACADC955F14C14CB869 |       3 | NULL        | 2023-05-30 10:42:13 | NULL       | NULL      | 2023-05-30 10:42:13 |          0 |       0 |     NULL |        2 |      |       | 2023-05-30 10:43:03 | NULL                |        0 |

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

5 rows in set (0.00 sec)

mysql> exit

Bye

[root@cyber ~]# 

修改后exit退出mysql，此时admin密码是默认admin@admin