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)
sudo su -
Login to MySQL Docker
docker ps
docker exec -it qmetryapp_db bash
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)
Type exit to exit the docker container.
Login to the QMetry application using the credentials - admin/Qmetry@123; the QMetry admin user should be able to log in now.