Locked out of ZenCart – Resetting Admin password in phpMyAdmin.

For some reason I need to keep this code super handy, not sure why but I often seem to get locked out of my Zen Cart admin account.

Found this lovely pain-free fix in the Zen Cart FAQs.

You simply navigate to the relevant database in phpMyAdmin and hit the SQL tab.

For Zen Cart v1.5.x, enter the following SQL QUERY:

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

For Zen Cart v1.3.9 and older, enter the following SQL QUERY:

DELETE FROM admin WHERE admin_name = 'Admin'; INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)

NB – Include your table prefix if necessary as below:

"DELETE FROM yourTablePrefix_admin ... " and "INSERT INTO yourTablePrefix_admin ..." VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);