Error: Invalid administrator login attempt

Rating: 5.0. From 3 votes.
Please wait...

The error may occur while trying to login to your oscommerce admin panel.

1. Open your database management tool (PhpMyAdmin or similar)

2. Open the SQL tab at the top

3. Into the SQL query window paste the following query and press Go button:

DROP TABLE IF EXISTS administrators;
CREATE TABLE administrators (
id int NOT NULL auto_increment,
user_name varchar(32) binary NOT NULL,
user_password varchar(40) NOT NULL,

4. When the query is complete open your osCommerce admin panel. You’ll be notified that there are no administrator account. Type your new admin username and password.

Now the admin account has been successfully created. Type the admin details again to enter the admin panel

This entry was posted in OsCommerce Tutorials and tagged admin, database, error, login, osCommerce, password, SQL. Bookmark the permalink.

Submit a ticket

If you are still unable to find a sufficient tutorial regarding your issue please use the following link to submit a request to our technical support team. We'll provide you with our help and assistance within next 24 hours: Submit a ticket

  • Fibudy

    Nice man..
    Thakns So Much !!

    I’m from brasil and I did it !

    No votes yet.
    Please wait...
  • Aji Prabowo

    thank you, I got this working on one of my site. many thanks

    No votes yet.
    Please wait...
  • Aji Prabowo

    Thank you for the tips. It works on one of my oscommerce site. Once again, many thanks!

    No votes yet.
    Please wait...
Live Chat
We help you to choose the right product.