How to reset the QMetry "admin" user password for server customers?

How to reset the QMetry "admin" user password for server customers?

In situations of forgotten/lost QMetry admin credentials, follow the below steps to reset the QMetry admin password back to default (i.e. Qmetry@123)

  1. sudo su -

  2. Login to MySQL Docker

    • docker ps

    • docker exec -it qmetryapp_db bash

  3. Login to MySQL, and run the below query

    • mysql -u[username] -p[password] qmetry -A

    • USE qmetry;

    • SQL query to update the QMetry admin password back to default - Qmetry@123 

      UPDATE USER SET userPassword="e2445b23bdfa6e32fe47378b5813414f245a488482be1a5652eda0defd337988560ee94fc8b0803bb88b309ff9e6bc1fd61258e26803afb3708a147978e86e17" WHERE loginId="admin" LIMIT 1;
    • \q (to exit mysql)

  4. Type exit to exit the docker container.

  5. Login to the QMetry application using the credentials - admin/Qmetry@123; the QMetry admin user should be able to log in now.