Resetting your osCommerce Password using PHPMyAdmin and MySQL

Written by Avesta Sabetian Sunday, 19 July 2009

Here, I will describe how to reset your osCommerce password using cPanel.

1) Login to your cPanel

2) Go to PHPMyAdmin

3) Open up the database which corresponds to your osCommerce installation, it will look similar to “_osc”. Click on it and it will open the database’s tables.

4) Click on “administrators” on the left hand side to open up the administrators table. After thats open, click on “Empty” on the top right hand and empty the table.

Done! Now when you visit your admin login page, the username/password you submit will be your new admin username and password. It should work out great, but if you run into any problems, please feel free to comment about them.

2 Comments

1. Andrew   |  Saturday, 19 February 2011 at 5:02 am

   indeed it works a treat! thanks
   tried md5, HA1, password via mysql, none worked. delete user does the job

   
2. razin   |  Monday, 20 February 2012 at 11:27 am

   get an error after i emptied it…

   Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘spin1111′@’184.168.46.219′ (using password: YES) in /home/content/48/8894748/html/admin/includes/functions/database.php on line 19
   Unable to connect to database server!