Zen administrator forgets password and retrieves password

1. Log in to deploy Zen Linux The server

/opt/zbox/run/mysql/mysql -uroot -p

2. Enter the default database password

Zen database root Default password 123456

3. Input ： show databases; It is shown as follows ：

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| zentao             |
| zentaobiz          |
| zentaopro          |
+--------------------+
6 rows in set (0.00 sec)

4. Input ： use zentao;

MariaDB [(none)]> use zentao;
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
MariaDB [zentao]>

5. Query user account and password , perform ：select id,account,password from zt_user;

MariaDB [zentao]>  select id,account,password from zt_user;
+----+---------------+----------------------------------+
| id | account       | password                         |
+----+---------------+----------------------------------+
|  1 | admin         | c0a3d0b20f617a23553dfa361c0e7088 |
|  2 | liujin        | c0a3d0b20f617a23553dfa361c0e7088 |
|  3 | wangchengbing | c0a3d0b20f617a23553dfa361c0e7088 |
|  4 | zhaopengwei   | c0a3d0b20f617a23553dfa361c0e7088 |
|  5 | gupengfei     | c0a3d0b20f617a23553dfa361c0e7088 |
|  6 | liyucai       | c0a3d0b20f617a23553dfa361c0e7088 |
|  7 | fujunshen     | c0a3d0b20f617a23553dfa361c0e7088 |
|  8 | puchenglin    | c0a3d0b20f617a23553dfa361c0e7088 |
+----+---------------+----------------------------------+
8 rows in set (0.000 sec)

MariaDB [zentao]>

You can see the user name and password in the table above , also id, Now we're going to id Change the password

6. modify , perform ：update zt_user set password='e10adc3949ba59abbe56e057f20f883e' where id=1;

MariaDB [zentao]> update zt_user set password='e10adc3949ba59abbe56e057f20f883e' where id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [zentao]>

Displaying the above information indicates that the password has been modified successfully

Encrypted string ：e10adc3949ba59abbe56e057f20f883e Indicates that the password is ：123456

Now the password of the administrator has been changed to ：123456, You can go to the page to log in to Zen