Cannot reset admin password

[danbro0811]

Thanks for all your help. Still not getting it. I'm into an tech area I really know nothing about. All of this would be unnecessary of course if Zen-Cart would just resend me my password when I click "Resend Password" on the Admin login page. Any idea why that's not happening? I am sure the Admin user name is correct.

[DrByte]

Why are you pasting "FROM/INTO prefix_admin" in the first place? That's definitely invalid syntax, and not part of the code suggested in the article.

[danbro0811]

There's was a message below the code which said to add that, which I did only after both versions of the code failed to work. To recap, here are the four things I tried:

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

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

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

FROM/INTO prefix_admin
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);

I gather that neither of the last two are correct. But what about the first two? Are they both wrong, too? If so what is missing? Again, I'm not a tech guy. So i would need to know exactly what I should be pasting in. Thanks.

[RescoCCC]

Log in to your database and look at the "admin" table. Does it just read "admin" or is there something appended to the front of it? If there is something that is appended to the front of it, this is a prefix and the same thing needs to be appended to the front of "admin" in the sql patch.