Reset Admin Password

One of the easiest way to reset the data in the database. 

1. Log into PHPMyAdmin, to go your opencart database and go to SQL tab. 

2. Run query below - replace: reallylongpassword, admin username and 'oc_' with yourdatabase prefix

UPDATE `oc_user` SET `password` = md5('really!!long!!!secure!!!!password') WHERE `username` = 'admin';


Another way with only FTP access upload a PHP script which runs the above query.

E.g. paste this into a file reset-admin-password.php and upload to the root (same folder as config.php). Then visit this file in a browser or command line.


<?php

require_once('config.php');
if (file_exists(DIR_SYSTEM . 'library/db/' . DB_DRIVER . '.php')){
require DIR_SYSTEM . 'library/db/' . DB_DRIVER . '.php';
} else {
require DIR_SYSTEM . 'database/' . DB_DRIVER . '.php';
}
require DIR_SYSTEM . 'library/db.php';
$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$sql = "UPDATE `".DB_PREFIX."user` SET password = md5('reallylongpassword') WHERE username = 'admin'";
$result = $db->query($sql);
var_dump($result);
die('DONE!');

Featured

Professional Email Template - Advanced

Professional Email Template - Advanced

Responsive HTML Email template - not only will your emails look professional on all desktop computers, it will resize beautifully for viewing on mobile devices! The aim of this new extension was to build a configurable email template which can be ea

£29.00

Modifications Manager

Modifications Manager

Edit modifications (ocmod code) easily from the admin using a xml code editor. The xml ocmod is stored in the database table 'oc_modification' and can be hard to make changes... this extension solves this :) Add/edit modifications. CodeMirr

FREE

PDF Order Invoice

PDF Order Invoice

Attach PDF invoice to order update email or customer download from their account. Works well with Advanced Email Template

£10.00

Admin Order Status Updater

Admin Order Status Updater

Quickly and easily update orders with the same order status and auto populated message.Works very well with email template extension that handles parsing the shortcodes (e.g: {{ firstname }}) to real data. ..

£10.00