Can't log in to admin...

[techbot]

I have this store running already on this server in another location, and again on another website on this same host. It's just this newest version of Zencart that seems to be kicking my ########

[khopek]

I haven't tried this yet, but I can't get in AT ALL. I have tried resending the password 3 times and everytime I just get a message saying invaild username or password. My website was working perfectly until a week ago when it suddenly decided not to let me log in.

[Goshawk]

Perhaps you can go into your MySQL database, and look at your username/password.

[techbot]

There's a lot of help on these boards, but everyone seems to think that each person on here knows how to work with databases :) I figured this out the other night on my own...I'm by no means a MySQL guru, but this worked.

First log into your host and do whatever you need to get to phpMyadmin.

Once you're in there, click on the "zen_admin" in the left column

This opens up that table within the database. You should now see some values there in the right column.

Click and put a checkmark next to admin_pass and then go to the top and click on the Browse tab

Now you'll see the admin name, id, email and an encrypted password.

Click on the pencil to the left of these

Now these fields are open for you to redo. I didn't really have any luck changing my admin name, but the email and pass worked fine.

To change the password...simply erase and change that long encrypted password and then go to the immediate left to that drop down field that says Function. Scroll down and choose MD5, then click on the "Go" button at the bottom.

And you've just changed your admin password. Try to log in like that and see if it works.

[khopek]

I'm so glad you put step by step instruction on how to do this. It really helps.

Unfortunately, I still cannot login. Here is what it says in my database:

admin_id admin_name admin_email admin_pass admin_level
1 (name) (email) (encrypted password) 0

I changed the password, but when I try to login, it still gives me the invalid username or password error. I don't even know if the admin id or level are right.

This is getting so frustrating....I'm going to back up everything just in case I have to reinstall zencart. ugh.


Also, the username that is *supposed* to be used to login, I have not seen in here....

[techbot]

Did you make sure to change that "Function" dropdown to MD5? Use the username "admin" and the new pass that you put in there

[khopek]

yes I did change the Function dropdown to MD5. I also tried using username admin. Still doesn't work.

I have tried everything I can think of...

My original admin username, my name, my store email, and now tried just admin.