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]

Dear Sorter

For the Evaluation Embedded HSQL Database

To change the password to admin 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