I forgot my Admin password to BigAnt server, how can I reset it?

If you forget Admin password of your BigAnt console, you may follow instruction below to reset your password in your database.

This is an instruction on how to reset your BigAnt server console password, please go to your server desktop and do following steps:

Note, following instruction is based on BigAnt running with embed MySQL database, it is similar process if you are running SQL database.
  1. Run > cmd > to open command line
  2. Enter the bin directory of mysql, input following sentence into command line
    cd C:\Program Files (x86)\BigAntSoft\IM Console\im_dbserver\bin
  3. Enter mysql db
    mysql -u root -p

    Enter password: www.upsoft01.com
  4. select antdb
    use antdbms_default;
  5. change password of admin to 123456
    update hs_user set USER_PWD = "e10adc3949ba59abbe56e057f20f883e" where USER_LOGIN = "admin" or USER_LOGIN = "superadmin" or USER_LOGIN = "security" or USER_LOGIN = "auditor" ;
  6. change password of console admin to 123456
    mysql -u root -p
    use antdbms;
    update sys_admin set USER_PWD=" e10adc3949ba59abbe56e057f20f883e" where USER_LOGIN="admin";
  7. \q;
    Close the command line
  8. Launch your BigAnt console, and login with admin account and default password 123456