English
Язык
Українська
Lost your OpenCart store administrator password? There are several ways to reset your OpenCart password, and we will go through each of them step by step.
If you are using OpenCart 2.x, 3.x or later, you will find a password reset option on the admin login page. To do this, go to your admin panel login page and click the “Forgot your password” link, or directly open http://yourdomain.com/admin/index.php?route=common/forgotten and enter your administrator email address. Then follow the link sent to your email and set a new password.
What to do if you forgot your OpenCart administrator email and password
You can also recover your OpenCart administrator password by editing the MySQL database via phpMyAdmin. To do this, go to your hosting control panel and log in to phpMyAdmin. Open the database used by your OpenCart store. Locate the “oc_user” table (or xyz_user, where xyz is your database prefix). To find the users table, scroll down through the list of database tables. Please refer to the image below for guidance.
Open the table. Here you will see all user accounts. Find the row with your administrator username. Double-click the password field and insert the value “637b9adadf7acce5c70e5d327a725b13”. After that, you can go to the login page and use the username with the password value “yourpassword”. Do not forget to change your password to a stronger one from the OpenCart admin panel afterward.
Alternatively, you can run an SQL query through phpMyAdmin by setting a new password directly. Go to the SQL tab, enter the query, and click the Execute button.
UPDATE `oc_user` SET `password` = md5('yourpassword') WHERE `username` = 'admin'where yourpassword is your desired password and admin is your username.
What to do if you do not remember your OpenCart password, admin email, or do not have access to the database via hosting panel
In this case, you can find database connection details in the config.php file by logging in via FTP client (see lines 25–31 in the screenshot), and then connect to the database using a MySQL manager.
And finally, in my opinion, the easiest and fastest way to restore access to the OpenCart admin panel
If you forgot your OpenCart password, administrator email, and login, and also do not have access to your hosting control panel, you can create a new administrator account.
To do this, create a new file named user.php in the root directory of your site with the following content:
<?php
error_reporting(-1);
header('Content-Type: text/html; charset=utf-8');
include('config.php');
$db = mysqli_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$user = 'Login'; // User login
$password_user = 'Password'; // User password
$password = md5($password_user);
$mail = 'name@johndoe.com'; // User email
$query_content = "INSERT INTO `" . DB_PREFIX . "user`
(`user_group_id`, `username`, `password`, `salt`, `firstname`, `lastname`, `email`, `image`, `code`, `ip`, `status`, `date_added`)
VALUES
(1, '$user', '$password', '', '$user', '', '$mail', '', '', '127.0.0.1', 1, '2000-01-01 00:00:00');";
$result_content = mysqli_query($db, $query_content);
if (!$result_content) {
echo "<p>User <strong style=\"color:red;\">$user</strong> was not created!</p>";
} else {
echo "<p>User <strong style=\"color:green;\">$user</strong> with password <strong style=\"color:green;\">$password_user</strong> has been successfully created!</p>";
}
?>
After executing the file, open http://yourdomain.com/user.php. You will see a message confirming successful user creation along with login credentials for the OpenCart admin panel.
Now you know how to reset your OpenCart password and regain access to your store’s admin panel easily.
Comments