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?