Can't remember last password

Question

Hello all

Please, I don't remember my password and I did'nt configure the SMTP server to send email.

I see that it is possible to use SQL query , but I don't know how to acces to my local JIRA database.

Maybe , is it possble to install again JIRA Core that will provide me the possibility to create a new administrator user?

Yogesh Mude_u145qk · Answer

Ok No worries..

You can use the below command then..

1. open the CMD prompt(system32)

2. Run the below command

psql -U postgres -h localhost

3. Check the database Name and run the below command to reset the passowrd.

$ update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='admin';

Jean-Paul Cabon · Answer

Hello Yogesh Mude

Unfortunately, it is Window 10 Pro.

Yogesh Mude_u145qk · Answer

Hi @Jean-Paul Cabon

Welcome to the community!

Can i ask ..

1. On which OS(Windows/Linux) you have hosted Jira software?

If it's a Linux then please use the below commands to login into the database and try to reset the password...

Linux: Make sure you should have the jira internal directory user.

1. Open the terminal.

2. login to a database

$ sudo -i -u postgres

3. check the database Name

$ \l

4. connect to jira database

$ \connect <database_name>

5.set the password for user admin and the current password is "sphere"

$ update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='admin';

After successfully updated the password for admin user (You should provide your internal directory username instead of admin) then login with "sphere" password and then change the password that you want to use.