Change the Master Password through phpMyAdmin

If you don't have the client's password or you can't remember your master password, but you do still have access to the database, you can still load the master password so you'll be able to log in to the site in the future. The following FAQ describes the process of changing the password to a default 'master1':

  1. Log in to phpMyAdmin on the client's site.

  2. Select the client's database.

  3. Select the 'SQL' tab.

  4. Enter the following:

    UPDATE opc_vars SET AdminUser='d5802d05bbf0881de2fd823c9560619e' WHERE ID='1';

    and press 'Go'. (Note: If you use a database prefix other than 'opc', change the prefix in the above query accordingly.)

  5. Go to the client's storeadmin area at clientssite.com/storeadmin/?master=y and log in, using the following:

    User Name: admin (or whatever the "SB_ADMIN_USER" value is in the config.php file)

    Password: master1 (which is your new temporary master password)

    Master Key: (whatever the "SB_MASTER_KEY" value is in the config.php file)

  6. Click "Change Master Password" and reset the master password to something else. You can now use this new password when logging in to the site.