James878 Posted February 1, 2008 Posted February 1, 2008 Please help me ..... I have lost my admin password and am not able to login... How can i retrieve or change my password? Please help
celshader Posted February 2, 2008 Posted February 2, 2008 Please help me .....I have lost my admin password and am not able to login... How can i retrieve or change my password? Please help In the mysql database find the table called 'administrators' You can then change the password to whatever you want. But you must encrypt your new password 1st. Does anyone know what Oscommerce uses for encryption? MD5 is most commonly used for php and mysql applications and you can encrypt your new password here http://www.md5encryption.com/ You should double check what oscommerce uses though.
James878 Posted February 2, 2008 Author Posted February 2, 2008 HI... I did as you said..i logged into mysql and found administrators tab... But then on i tried to change the password but nothing happened.... Could you please tell me the process a little more briefly... Thank you
James878 Posted February 3, 2008 Author Posted February 3, 2008 hi....i tried changing it and i believe i did...but still it says invalid login attempt......please help In the mysql database find the table called 'administrators'You can then change the password to whatever you want. But you must encrypt your new password 1st. Does anyone know what Oscommerce uses for encryption? MD5 is most commonly used for php and mysql applications and you can encrypt your new password here http://www.md5encryption.com/ You should double check what oscommerce uses though.
user99999999 Posted February 3, 2008 Posted February 3, 2008 If you dont have a store account already then create one. Copy the encrypted password from your customer table to your admin table. I think it will work.
chipshot Posted February 3, 2008 Posted February 3, 2008 delete the password from phpmyadmin log in then create a new password
James878 Posted February 3, 2008 Author Posted February 3, 2008 I have absolutely have no knowledge in this regard...... The problem is i have logged in to the administrator table and have changed the user name and pass both but still it is showing invalid attempt. I have encrypted the new pass deleted the old one but still it just wouldnt work.... I dont understand what wrong am i doing....... If you dont have a store account already then create one. Copy the encrypted password from your customer table to your admin table. I think it will work.
chipshot Posted February 3, 2008 Posted February 3, 2008 looks like user99999999 gave you the solution that should work go to your store, create an account give it a password of (fuzzybunny) go into phpmyadmin / your database / to a table call customers find your new account copy the encrypted password create a new administator paste the encrypted password in (you know that's fuzzybunny) log in to admin with the new account... password (fuzzybunny)
James878 Posted February 4, 2008 Author Posted February 4, 2008 Hey it worked.............. Thank you so much..................... I really appreciate your help......... looks like user99999999 gave you the solution that should work go to your store, create an account give it a password of (fuzzybunny) go into phpmyadmin / your database / to a table call customers find your new account copy the encrypted password create a new administator paste the encrypted password in (you know that's fuzzybunny) log in to admin with the new account... password (fuzzybunny)
kendrick Posted October 8, 2008 Posted October 8, 2008 Hey guys. I have the same problem? How do i create a new account in order to replace the password for the admin?
markg-uk Posted October 8, 2008 Posted October 8, 2008 Hey guys. I have the same problem? How do i create a new account in order to replace the password for the admin? You don't know how to create an account on your own store?
♥geoffreywalton Posted January 21, 2009 Posted January 21, 2009 If you delete the admin user in the administrators table in phpmyadmin you are prompted for a new user and password the next time you go to the admin area you are prompted for these details. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
Andy H Posted July 28, 2011 Posted July 28, 2011 I have a variation on this problem. I haven't forgotten my password. I know what is is, but the admin login won't accept it. I have just done a fresh installation of 2.3.1. I typed in the username and password I wanted but when I tried to log in it said "Error: Invalid administrator login attempt." I've tried both the solutions in this thread - using phpmyadmin to copy the password from a new customer (it didn't match so I wonder if the encryption is different for administrator accounts?) and deleting the admin user so it offered to create a new one. Either way, when I try to log in, I get the same error. I have .htaccess set up to require a login to get into the folder, and that works okay. I set it up by manually editing .htaccess and using a password file I use for another part of the site. I filled in the "Administration Directory Name" with a directory name other than admin when I installed it. That seems to have gone smoothly, but I wonder if that could be the reason it doesn't work? There was no mention of that option in the documentation, so I was just guessing it would rename the admin directory, which it did.
Andy H Posted July 28, 2011 Posted July 28, 2011 Update: I found the answer here: http://www.oscommerce.com/forums/topic/369402-cant-login-to-new-231-install/page__st__20__p__1594733#entry1594733 - The .htaccess username and password has to match the one used for the administrator account. I was sceptical, but it works.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.