Locked Myself Out Of My Newly Installed Zen Cart

[queenpictoria]

Hello.

 

I ventured out to other forums and I come back here once again.

This question is humbling, but it may not have a place on TCH Forums.

Just let me know.

 

I may have to uninstall the shopping cart and re-install it because

I cannot find my notes with all the USERNAME and PASSWORD!!!

How do I retrieve both of them?????

 

I am not an idiot. That is not my excuse.

Intelligence is not a defense.

 

Anyway, can anyone tell me the facts.

 

The support forum for Zen Cart is slient.

Any experience in this blunder?

 

I can reinstall and start anew.

 

Regards,

queenpictoria

Edited August 29, 2008 by queenpictoria

[TCH-Bruce]

I've never used Zen Cart but I assume that it uses a database. I would imagine you can find the user name and reset the password using phpAdmin in cPanel.

 

I also found this and this and this doing a Google search.

[queenpictoria]

I've never used Zen Cart but I assume that it uses a database. I would imagine you can find the user name and reset the password using phpAdmin in cPanel.

 

I also found this and this and this doing a Google search.

 

 

Hi Bruce,

Thanks for your help.

 

I am looking to log back into the Zen Cart, and the last link you gave me is supposed to help me.

I tried it twice today, but maybe the third time will do it. I want to paste the verbage here so you can

look at it. Do you know what it is saying?

 

I know the Database Username and Password, but I am not sure how to put it in here.

I tried and have failed.

 

What do you see?

 

1. If you can log in to your Zen Cart admin using another account, please do so, and reset/modify the other admin password as needed via Admin->Tools->Admin Settings

 

2. If you can't remember your admin account or password, there's still hope.

 

The first thing you can try is to click the "Resend Password" button and enter the admin email address.

 

If for some reason that doesn't work for you, you can create a temporary admin account in order to log in.

 

Open your phpMyAdmin (supplied by your hosting company), click the "SQL" tab and run this query:

 

DELETE FROM admin WHERE admin_name = 'Admin';

INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)

VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

 

If you are using a prefix for your database tables, you'll naturally need to add that prefix to the table name above.

ie. "... FROM/INTO prefix_admin ...".

 

You should now be able to login using the following details:

 

Username: Admin

Password: admin

 

Be sure to use proper case. ie. 'Admin' for username, not 'admin'.

 

 

After you log in, remember to delete this temporary admin account and create a new one from Admin->Tools->Admin Settings

 

I went into the SQL button and put in what I thought was the correct values but do not know how to read it.

 

Let me use fake Username and Password and perhaps you can tell me where to put what in where.

 

Fake Username: GreenTea

Fake Password: YogiBear

 

If you just want to throw this out in left field I understand. :)

 

If I do not find the answer soon, I will just uninstall it and start over.

It won't kill me. I've wasted the whole afternoon because I lost my notes.

 

 

 

Thanks,

April

[TCH-Bruce]

Do exactly what it says to do. Then log in with Admin and admin for the password. Then you can change the user and password from within Zen Cart is what I am reading.

 

If you just installed it how much have you done with it. Maybe it would just be simpler to delete it and reinstall it.

[queenpictoria]

Do exactly what it says to do. Then log in with Admin and admin for the password. Then you can change the user and password from within Zen Cart is what I am reading.

 

If you just installed it how much have you done with it. Maybe it would just be simpler to delete it and reinstall it.

 

 

Bruce,

 

I do not know how to read it.

 

I'll just uninstall it.

 

No more.

 

Thanks.

[OJB]

If you haven't taken the plunge and uninstalled follow these instructions.

 

 

Log into your Cpanel (go to http://www.YOURSITENAME.com/cpanel)

 

Enter the username and password provided to you by TCH to log in.

 

Scroll to the bottom of the page and find the link for PHPMyAdmin

 

Click that link, when PHPMyAdmin loads in a new window you should be presented with a drop down list (top left of the page) with a list of all your databases in.

 

Click on the database you set up for Zen cart.

 

Take a look at all the tables in your database (they are listed in a column on the left hand pane. Do they all start with a prefix? For example zc_admin, zc_whatever.. if they do, then zc_ is your table prefix, if they don't all have the same prefix then you don't have a table name prefix.

 

Then click on the SQL tab in the right hand pane.

 

Copy this code:

 

If you dont have a prefix:

>DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

 

If you do have a prefix:

>DELETE FROM yourprefixhere_admin WHERE admin_name = 'Admin';
INSERT INTO yourprefixhere_admin (admin_name, admin_email, admin_pass, admin_level)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

 

Paste that into the SQL query box that has appeared and run the query. It should say 1 row was deleted and 1 row was added.

 

Then you should be able to log into your zen cart using the following:

 

Username: Admin

Password: admin