2.14.3.6. Change administrator password in OpenCart

Attention!

The current administrator password cannot be retrieved because it is not stored on the site in plain text — only its hash is stored. The password can only be changed to a new one.
  1. Open the "CMS install" section.
  2. Click "Reset password":
  3. Select the user, specify the new password, and click "Change password":
  1. In the site configuration file, check the name of the database it connects to.
  2. Open database in phpMyAdmin.
  3. Run the following SQL query, specifying the new password instead of new_password:
    UPDATE oc_user SET `password` = MD5('new_password') WHERE user_id=1;

    If table names in the database do not start with the standard oc_ prefix but use a different prefix, make the corresponding change in the SQL query.

  4. Check sign-in to site admin panel
Content
    (8)