AlegroCart open source E-commerce
Web hosting by Host1Plus

Lost Admin Password

knowledge base and frequently asked questions

Lost Admin Password

Postby Brent » Wed Dec 29, 2010 2:40 pm

If you have somehow lost your administrator password, the following SQL will help you recover it.
You go to your store database in PHPMyAdmin. Run the following query.
You can replace the username tempadmin if you like.
Run as is, your user name will be tempadmin and the password will be 12345

Code: Select all
INSERT INTO `user` (`user_id`, `user_group_id`, `username`, `password`, `firstname`, `lastname`, `email`, `ip`, `date_added`) VALUES ('1', '1', 'tempadmin', '827ccb0eea8a706c4c34a16891f84e7b', '', '', '', '', '1000-01-01 00:00:00') ON DUPLICATE KEY UPDATE username='tempadmin', password='827ccb0eea8a706c4c34a16891f84e7b';

As soon as you have done this, login to your store and change the user name and password to something more secure.
User avatar
Site Admin
Posts: 4388
Joined: Sat Dec 12, 2009 3:35 pm
Location: Canada eh

Return to FAQ / Layouts / Knowledge Base

Who is online

Users browsing this forum: No registered users and 1 guest