Search

HostGator Web Hosting Help

osCommerce Lost Password Fix

Summary

OSComerce does not have an easy to use Password Reset tool. Instead you will need to remove the existing administrator account and then create a new one.

How to Reset Your OSCommerce Administrator Account

  1. Login to your hostgator_sg Control Panel
  2. Click the phpMyAdmin icon, located in the Databases section of the cPanel.
  3. From the left hand side of the page, choose your osCommerce database name (typically something like _osc1).
  4. Again, from the left hand side choose the table named administrators.
  5. Click the tab labeled Empty, located about the middle of the page.
  6. You will be prompted, "Do you really want to : TRUNCATE TABLE 'administrators' ?", Click the OK button.
  7. Now return to your osCommerce site and try to login to the admin area. The site will state that there is not currently a user, so you can be the first.
  8. Enter the desired admin name and password into the login area and click the Login button.
  9. Nothing will seem to happen, but your site just accepted your submission as the new administrator user.
  10. Again login with the newly created administrator username and password you just typed in the previous step.


Was this resource helpful?
Helpful Unhelpful


Did this resolve your issue?
Solved Unsolved


Please add any other comments or suggestions about this content:





Recommended Help Content

How To Reset MySQL Database User & Password
This article will explain how to change the password for a database in the event that the original password is lost.
Knowledgebase Article 263,165 views tags: database mysql password

Reset a WordPress Password with phpMyadmin
This article explains how to reset a lost WordPress password using phpMyAdmin.
Knowledgebase Article 203,266 views tags: password phpmyadmin wordpress

OSCommerce will not keep my sessions between HTTP and HTTPS.
When I try to log into my OSCommerce shopping cart using https://secure.HostGator.sg/~username url, my shopping cart isn't the same. It is as though I have 2 carts, one for HTTP (unsecure) an
Knowledgebase Article 197,569 views tags: commerce cookie oscommerce ssl

Related Help Content

MySQL Database Access Outside of cPanel
How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password?
Knowledgebase Article 282,277 views tags: access grant mysql password permission

Password Reset
How to reset various passwords associated with your account
Knowledgebase Article 163,169 views tags: change password reset update

How to Reset Your Login Password
How do I change my Control Panel password?
Knowledgebase Article 1,713,513 views tags: change cpanel password passwords protect

Password Protected Folder Gives Continual Prompts
What should I do if I am having problems with multiple password prompts on my password protected directory?
Knowledgebase Article 242,128 views tags: folder password protect

Setting a Password for the Main MySQL User
I am prompted to set a new MySQL password. What does this mean and how do I change it?
Knowledgebase Article 248,860 views tags: connect database mysql password phpmyadmin username

Password Types
This article explains the different password types for your hostgator_sg account.
Knowledgebase Article 233,528 views tags: billing cpanel hosting main password

Reset Joomla Password
How do I reset my Joomla password?
Knowledgebase Article 220,761 views tags: joomla password

Resetting the Password for an Email Account
Instructions for restting your Email Account's Password through cPanel or Webmail
Knowledgebase Article 606,459 views tags: email forgot password reset webmail