user password stored in which table in jira 4.4.1?

[fabby]

can anyone tell me user password stored in which table? not the database user and password.

the user stored in dbconfig.xml is for mysql database admin user(my jira's database type is mysql).

and i've known in table "cwd_user" stored all jira users ,but no password.

[Dieter]

cwd_user stores the hashed password in attribute credential.there is no way to get the clear text password but you can recover passwords as described in http://confluence.atlassian.com/display/DOC/Restoring+Passwords+To+Recover+Admin+User+Rights This is for confluence but should work for Jira as well

[Dieter]

More information can be found here: https://developer.atlassian.com/display/CROWDDEV/Database+Schema+and+Example+SQL+for+Crowd

[fabby]

thanks very much!

[Dieter]

if you consider the answer helpful please vote for or accept it :-)

[fabby]

it's jira 4.4.1

[Renjith Pillai]

Which product?