Reset StoreGrid web console username and password

Description

StoreGrid user name and password can be reset by following the steps mentioned below:

Details

StoreGrid user name and password can be reset by following the steps mentioned below:

  1. Stop the StoreGrid application.
  2. Go to the folder location “<StoreGrid_Home>/lib/” (for Linux) OR <StoreGrid_Home>/lib/sqlite” (for Windows).
  3. Access the StoreGrid client database using the commandsqlite.bin <DBStorageLocation>/data/sgclient.db (for Linux)sqlite3.exe <DBStorageLocation>/data/sgclient.db (for Windows)
    The <DBStorageLocation> is value of the “Path” attribute under “DBStorageLocation” tag in “SGConfiguration.conf” file under the “<StoreGrid_Home> conf” folder. By Default the DB Storage location will be <StoreGrid_Home>.
  4. Insert an additional user to the database using the following query:insert or replace into SG_USER values (1,1,’admin’, ‘21232f297a57a5a743894a0e4a801fc3’);where, “admin” is the user name, replace it with your preferred user name, and ”21232f297a57a5a743894a0e4a801fc3” is the encrypted password (the value given here is hard coded for “admin” – password
  5. Start the StoreGrid application.
  6. Now you can login to the StoreGrid web console using user name “admin” and password “admin”.
  7. After logging in to the StoreGrid web console, change the password to the desired value by going to “Administration -> Advanced Options -> User Management (tab)” .