forgot admin password in confluence and using h2 database

Sorter Jenkins

This question is in reference to Atlassian Documentation: Unable to Start Confluence Due to I/O errors during LOB access

forgot admin password in confluence and using h2 database, is there any way to recover that password.

 

Siddheshwar mhetre_l4zeyg

Dear Sorter

For the Evaluation Embedded HSQL Database

To change the password to <strong>admin</strong> for a given username:

1. Shut down Confluence.
2. Open <confluence-home>/database/confluencedb.script, or confluencedb.log if the .script file looks empty.

3. Search for:

   INSERT INTO CWD_USER VALUES(

4. Keep searching until you find the appropriate user, then replace their password with the hash value above.
5. Save the file.
6. Restart Confluence.

For more about restoring password please check below link

https://confluence.atlassian.com/conf57/restoring-passwords-to-recover-admin-user-rights-701435450.html

Regards,

Siddheshwar