How to reset OpenCart 2+ administrative password?

php opencart2.x
Slavic picture Slavic · Mar 6, 2015 · Viewed 13.6k times · Source

Apparently the new (v2) OpenCart's password encryption scheme is not a simple md5 hash. I attempted to search the net for a way to reset the admin password after I changed hosts for my OpenCart installtion but could not find anything.

Thank you.

Answer

Jay Gilford picture Jay Gilford · Mar 6, 2015

If you just need to regain access, and change your password then you can do so pretty easily. Open system/library/user.php (system/library/cart/user.php in later versions) and find the line beginning

$user_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "user WHERE username =

Before the WHERE put a # changing it to

$user_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "user #WHERE username =

and save. This allows you to log in using the first account (usually the default admin account) without any user and password. As soon as you do, reverse this and save again. You'll still be logged in and can edit the user data editing the password as you wish

Related questions

How can we use opencart events?

I have searched a lot about opencart triggers but didn't find a proper example. In opencart 2.0 there are triggers on which developer can hook function and perform something just like wordpress action and filters i guess. For example in catalog/…

Read More
Adding an admin page on OpenCart version 2

I am havin a problem adding an admin page to Opencart2, and following the answers on pretty much identical questions on SO do no help, so I beleive the problem is specific to OC2. Following the answer at this question …

Read More
Modification requires a unique ID code! Opencart OCMOD

In Opencart 2.0.1.1, I tried to upload an OCmod configuration file with right name format .ocmod.xml but I get the error Modification requires a unique ID code!

Read More