For anyone needing to reset their password manually in the database, have a look at this section on our troubleshooting page:

https://github.com/adaptlearning/adapt_authoring/wiki/Troubleshooting#how-do-i-change-my-password