New to Zen Cart - Lost Username & Password

Hi.

I have misplaced both the username and password for the Zen Cart I am configuring.

I tried using this in SQL:
DELETE FROM admin WHERE batteryb = 'Admin';
INSERT INTO admin (batteryb)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

The instructions are typically vague and assume I know
what they are talking about.

Please help if you can.
I have a deadline and if I have to trash my work and do it
again I'd better get on with it.

queenpictoria

Perhaps this FAQ will help? https://www.zen-cart.com/tutorials/index.php?article=2

Kim,

That is quite a blow-off.
You must not know.

I don't need your advice.
I need help.

I already read that. Can't you tell by my notes.

Please leave me alone.

here is a key question......do you have a prefix on the tables?

oh and you might consider being nicer to Kim......ahhhh she runs this place, as in one of the developers and is a great believer in teaching you how to fish before handing you the fish...

Try this:

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

I'm sorry you found the instructions hard to follow.

The instructions aren't vague. They're literal. You're supposed to run the query exactly as it's listed in the FAQ article.
Then, as the article says, you'll have an Admin username in your database named "Admin" with a password of "admin", with which you can log in ... and then you can add new admin usernames as you wish ... and delete the generic one once you're happy with the new ones you've added.

queenpictoria:

Kim,

That is quite a blow-off.
You must not know.

I don't need your advice.
I need help.

I already read that. Can't you tell by my notes.

Please leave me alone.

queenpictoria, your attitude & manner are pompous and not deserved.
Have you never had someone misunderstand what 'you' were trying to tell them?
Perhaps you were having a bad day?

Anyway, for your benefit and those reading this thread in the future, this looks like where you went wrong.

You put:

DELETE FROM admin WHERE batteryb = 'Admin';
INSERT INTO admin (batteryb)
VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

https://www.zen-cart.com/tutorials/index.php?article=2 says to:

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);

Although the Tutorial could state that you do not change anything, except if there is a prefix used which it does mention, your presumption that you needed to change "admin_name" to "batteryb" was incorrect.

If, for example, one is using a prefix of "zen" then they would run this query:

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

Other than the prefix, nothing else is changed.

The results of running the above query:

• if there was a login using Admin, the password has now been changed
• if there was no login using Admin, then one has been one created

Also, in your post in your hosting company's forum you said that the Zencart forums were 'silent' about your question. This is 'silent'?

Seriously, you owe Kim an apology here.

I understand being stressed out...but if someone has 31,000 posts, it's safe to assume they were not all to blow people off.

I was in a real pickle, and running into this thread saved my hide (I didn't realize that changing my admin name would change the login credentials)

Hi,

I tried to do this and all i got was

Error

SQL query:

DELETE FROM admin WHERE admin_name = 'Admin';

MySQL said: Documentation
#1046 - No database selected

How do i find out if i have a other prefix?
sorry to sound stupid, im not good at this kind of thing.