Lost Admin Password
Posted: 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
As soon as you have done this, login to your store and change the user name and password to something more secure.
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';