Admin Password Reset?

English forums
1

Hello. I installed the latest version 4.7.6 of Oxid eShop. I restored my DB from v.4.6.5. Before the restore, I was able to login as admin. After DB import, I cannot login as admin. There is no password reset feature on the admin login page. Frontend is offline.

I changed password w/MD5 in oxuser via PHPadmin. Unsuccessful as I guess the salt prevented login. The password I used in the new install is the same I had in earlier version.

What can I do? Any ideas?

Thank you,

Ray

2

go to database administration interface (phpmyadmin?) and execute this:

update oxuser set oxpassword = MD5( CONCAT( 'mynewpassword', UNHEX( oxpasssalt ) ) ) where oxid='oxdefaultadmin'
2 Likes
3

Thank you Hebsacker. Unfortunately, other problems showed up where an error page displayed an endless loop error. I had this before and recall I ended up ditching the whole Db. So, I decided to delete the Db and start all over. Thank again for your response. I could NEVER get through this store setup without all you guys (and gals?) help. Cheers!

Ray

4

I just installed 4.8.5.
I was able to log-in as admin but now I don’t anymore.
Tried both ways to reset admin password.
When I use the email version I don’t get an email (not even in my spambox).
The command in phbmyadmin does not work either.
When I try to log-on after I ran it, at /admin the fields empty but I get no error message.
Any ideas?

Thank you

5

If it worked and now not anymore probably you (or your hoster) changed something. If you have just installed i suggest you delete files and db and install again.

6

If your shop runs in UTF8 Mode ($this->iUtfMode = 1 in config.inc.php) the field oxpassword in oxuser table must be collated in “utf8_general_ci”.

7

Dear Hebstacker,

I have had a similar problem, and while googling around, I have come by this post.

I have tried your solution and reset the password like you said. However, when I try to login in admin with my username and the new password, I get “Error! Incorrect username and/or password!”

Do you have any idea why is this happening?

Thank you in advance,
Ane

8

Have a look above…

9

Hi,
it must be possible to set the pw with the pw-reset-function on the frontend. I done that sometimes :wink:

10

… says who with what shop version, what changed, what hosting provider with what PHP / MySQL version etc?

11

actually with V4.10.6.

12

It works, but only if your admin account has an valid email address and oxid’s email delivery system is configured.

13

True. Another way would be to register as a new user and set this account to admin in DB.

1 Like