Manually reset a password in the database

If you forgot or lost your password and cannot login, you can reset the password in the database manually. You will need to use a third-party SQL client, either a command line tool or a graphical client like SQuirreL SQL Client.

• First locate the ID of the user you want to reset the password for.

  SELECT * FROM PERSON;

• The users are in the PERSON table, and the "admin" user usually has an ID of 1:
  

• Issue an UPDATE statement to the PERSON_PASSWORD table, using the ID of the user located in the previous steps. Change the question mark in the statement below to the correct ID.

  UPDATE PERSON_PASSWORD SET PASSWORD = 'YzKZIAnbQ5m+3llggrZvNtf5fg69yX7pAplfYg0Dngn/fESH93OktQ==' WHERE PERSON_ID = ?;
  

The above example uses a salted hash for the password "admin", assuming that the digest algorithm is still set to SHA-256. After issuing the above UPDATE statement, you should be able to login with a password of "admin". After logging in change the password as you see fit.