Log in to your MySQL server with the MySQL user that is granted all rights for the ChiliProject database (assumed here to be named chiliproject). The following line will reset the password of the user admin to admin:
update users set hashed_password="b5b6ff9543bf1387374cdfa27a54c96d236a7150", salt="82090c953c4a0000a7db253b0691a6b4" where login="admin";
Links
- [1] Source