Lost Admin Password

knowledge base and frequently asked questions
Post Reply
User avatar
Brent
Site Admin
Posts: 4459
Joined: Sat Dec 12, 2009 3:35 pm
Location: Canada eh

Lost Admin Password

Post by 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.

Post Reply