Sometimes you need to get in there and reset the password for oscommerce using phpMyAdmin.
In these instances, you do not just paste in a new password but you have to properly encode it first.
Here is a really handy tool to create a password hash for you, ready to be pasted into phpMyAdmin
for the admin side, you will need to edit the admin table and paste this into the password field for the account you need to set the password for.
Check out this easy oscommerce password generator
just in case that site ever goes down – I have lifted the code and hosted a mirror here:
osCommerce Password Generator
All credit goes to oscommercecustomsolutions.com
thanks, but where I can find the admin table?
Instalé su programa en mi hosting y no recuerdo la contraseña de entrada. Me podrían hacermela llegar a mi mail. Gracias
sorry dont speak spanish
i would like find my password, i forget it. i have installed his program and now i don´t remember it.
could you help me?
erm, not sure what else I can tell you that isn’t in the blog post…
A life saver…Create your new password with the link above and copy the password…go to PhpMyAdmin and open your database, click on administrator in the left column, click on the edit symbol (pencil) and paste your new password in the password field, click GO to save and your done.
Sorry, i don’t speak Spanish.
Great!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thanks, Very handy…..
Worked great for me. Thanks!
to good
OK, to simplify this… which is what anybody who searched and ended up here wanted in the first place. Step by step.
Log into you hosting backend, if not already installed, you need to install phpmyadmin, ( generally available as a ” one click install” by a lot of hosting companies now, if one click not available, go search for how to upload and install phpmyadmin )
Open phpmy admin,
View the database that relates to oscommerce (will probably be called oscomsomething by default if you didn’t custom name at install )
Find the table called “administrators”
CLick the option to “empty” this table.
when asked if you want to truncate, say yes.
exit phpmyadmin.
Go back to your oscom admin login link.
it will tell you that no admins are created and will allow you to create a brand new admin user and password.
Simple… and simple to explain to people who ask for help!!!
Hmm is anyone else having problems with the pictures on this
blog loading? I’m trying to find out if its a problem on my end or if it’s the blog.
Any responses would be greatly appreciated.
Thanks SomeDork !!
Thanks guys!!
Thanks, Thanks,