How to reset Zen Cart password via MySQL command line

If you're able to login just reset/update your password over Admin –> Tools –> Admin Settings

If not:

Find out Zen Cart version:

cat ./ |grep 'Zen Cart v'

Identify your db prefix:

cat ./includes/configure.php |grep prefix

If you're on 1.5.x version:

DELETE FROM prefix_admin WHERE admin_name = 'Admin';
INSERT INTO prefix_admin (admin_name, admin_email, admin_pass, admin_profile)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

If you're on 1.3.x version and older:

DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);


You should now be able to login using the following details:
Username: Admin
Password: admin
Be sure to use proper case. ie. 'Admin' for username, not 'admin'.
In v1.5.0 and newer, you will be prompted to change the password right away.

****After you log in, remember to delete this temporary admin account after creating a new one.
In v1.5.x you'll do that under the Admin Access Management tab.
In v1.3.x and older, it's under the Tools->Admin Settings option.


Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *