How to recover lost passwords and usernames?

[thestampnomad]

Two or three years ago I built a few zencart websites (Some was just for practice) but left them and havent touched them for years.
Now I cant remember the username and passwords and cant access the admin panels.
I do have access to the control panel of my hosting companies and can access the code.
Can somebody tell me where to go to find the admin username and passwords?
Thanks
Dean

[DrByte]

I just did a quick search in the FAQs for "admin password", and this link came up: http://www.zen-cart.com/content.php?...rd-(i-lost-it)

[thestampnomad]

I actually went through that but cant figure out what it is saying. It seems to have left out the first couple parts of the path where you need to go. Shouldent there be some place in the site coding where the password and username is located (Such as admin/includes/config.php or something similar?)

[DrByte]

No. The admin password information is in the *database*. Not in any .php files.

Use phpMyAdmin (provided by your hosting company) to access your database and run the statements as described in that article.
If you need help with how that works, contact your hosting company.

[thestampnomad]

Thanks. I am trying to do this but when I do I get this error message:
----------------------------------
Error
SQL query:

DELETE FROM admin WHERE admin_name = 'Admin';


MySQL said:

#1146 - Table 'amunre_zc6.admin' doesn't exist
---------------------------------------
Any ideas?

[dbltoe]

Did you open the database to see if there ARE tables there and that one of them is named admin?

[thestampnomad]

There are tables but none named admin. There is zen_admin, zen_admin_pages and several others with admin in the name but none just admin.

[dbltoe]

Then, your prefix is zen_
Following the instructions in the note, for 1.3.9 and older it would look like:

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

For 1.5.0 and newer:

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

[thestampnomad]

Thanks. That was complicated but I finally got it working. Learned a bit more about how the database works to. Thanks for the help

[thestampnomad]

I have most of my websites fixed now so thanks for that help.
But one of them I can access my admin now after resetting the passwords but I cant change the user in this domain.
Instead of the "Admin Access Management tab." All I have is "Admin home"
When I try "Tools" then "Admin settings" I get a general error saying "Page not found"
Any ideas what wrong with my website admin settings? (I upgraded to version 5)