brassblogs

I am notorious for this. In the past week, I’ve needed to reset my ZenCart password on 4 different sites, because I’ve lost or forgotten them. ZenCart isn’t quite as easy as WordPress when it comes to this. You’d think it would be – in WordPress, all you have to do is log into phpMyAdmin, browse your users table, find the admin and edit the password (making sure you save it as MD5) and that’s it. ZenCart? Nope. I don’t know why you can’t do this – I haven’t figured it out yet. The only way you can edit the password is by completely resetting it so that it then becomes “Admin” and “admin”.

So, you need to log into phpMyAdmin and choose your database, and hot the “SQL” button at the top of the screen. Drop in this bit of code:

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);

Note this line: DELETE FROM admin. “admin” should be replaced by the proper table name. If you have prefixes (like zencart’s default is “zen_” ) you’d want to be sure you’re selecting the right table by putting in the prefix you’re using. So in the default case, it would be DELETE FROM zen_admin.

Once you have that correct, then hit “go”, and now you can log in using “Admin” and “admin.”

You’ll also get an error message at the top when you log in. So be sure the first thing you do is create a new admin login and then delete the “Admin” one to take care of that.