Resetting your osCommerce Password using PHPMyAdmin and MySQL

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.

Posted under cPanel/Linux Hosting, MySQL, osCommerce, phpMyAdmin | RSS 2.0

2 Comments on Resetting your osCommerce Password using PHPMyAdmin and MySQL

  1. Andrew says:

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

  2. razin says:

    get an error after i emptied it…

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

Leave a Reply

Your email address will not be published. Required fields are marked *