"记录在Linux环境下找回禅道admin密码的方法"
使用root账号登录禅道安装路径下的mysql,root默认密码123456
1 /opt/zbox/run/mysql/mysql -uroot -p
2 Enter password:
成功进入mysql后提示如下:
1 Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 7Server version: 10.1.22-MariaDB Source distribution
2 Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
3 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
4 MariaDB [(none)]>
查看数据库,并使用zentao库
1 MariaDB [(none)]> show databases;
2 +--------------------+
3 | Database |
4 +--------------------+
5 | information_schema |
6 | mysql |
7 | performance_schema |
8 | zentao |
9 | zentaoep |
10 | zentaopro |
11 +--------------------+
12 6 rows in set (0.01 sec)
13
14 MariaDB [(none)]> use zentao;
15 Reading table information for completion of table and column names
16 You can turn off this feature to get a quicker startup with -A
17
18 Database changed
19 MariaDB [zentao]>
输入sql命令查看zt_user表root用户密码
1 MariaDB [zentao]> select id,account,password from zt_user where account ='admin';
2 +----+---------+----------------------------------+
3 | id | account | password |
4 +----+---------+----------------------------------+
5 | 1 | admin | c79077fb2a0b06ae6ccf62ddc7269026 |
6 +----+---------+----------------------------------+
7 1 row in set (0.00 sec)
8 MariaDB [zentao]>
密码使用MD5加密,修改当前密码为:
e10adc3949ba59abbe56e057f20f883e即123456
1 MariaDB [zentao]> update zt_user set password='e10adc3949ba59abbe56e057f20f883e' where id=1;
2 Query OK, 1 row affected (0.00 sec)
3 Rows matched: 1 Changed: 1 Warnings: 0
4
5 MariaDB [zentao]>
修改成功后即可使用密码123456在浏览器登录禅道admin账号。