Manual password reset in mysql DB?

**jgold723** · 5 Jul 2012, 04:32 PM

Is there a way to manually reset a user password (via MySQL) rather than the built in ZC automatic reset? I have having a terrible time with a user who just can't seem to reset his password. We've gone through the cycle multiple times and it just won't work.

I'd like to go straight into the MySQL DB and reset it there -- but I don't want to break anything.

Can this be done? Any suggestions?

**stevesh** · 5 Jul 2012, 04:40 PM

http://www.zen-cart.com/content.php?...rd-(i-lost-it)

**jgold723** · 5 Jul 2012, 06:23 PM

Thanks Steve -- this seems to be for the admin password, which is OK. The problem I'm having is with individual customers who forget their passwords and then have a hard time resetting them via ZC.

**stevesh** · 5 Jul 2012, 06:57 PM

Sorry, I misunderstood. There's no way I know of to reset a customer password using SQL, as the passwords are encrypted. What sort of problem are your customers having with the usual method ?

**jgold723** · 5 Jul 2012, 08:44 PM

The scenario seems to be their password stops working (or they forget it). They request a new one and that doesn't work.

I have asked them to send me the new password and it doesn't work for me either. But I don't really know if that's because they are copying the PW incorrectly or what.

So, ideally, I'd like to reset the password here, test it and then send it to them -- that way I know it's correct.

This seems to happen relatively frequently (say once a month at least).

I have tried changing my own password -- no problem -- so I'm guessing it's user error.

John

**dbltoe** · 5 Jul 2012, 08:50 PM

it just won't work

What is it? The customer's keyboard, the e-mail with the new password, the customer's ability to cut and paste the new password, the system will not accept the password, is caps lock on when the customer tries to type in the code, etc?

collective pronouns.

You might try creating a user yourself and experiment with a version of the method used for replacing admin passwords. Theoretically, if you use just the code for the password and then use "admin" (without the quotes) for the password, it should work.

NEW-- Was typing while you were typing.... You can also temporarily change their e-mail to yours and send a password that way.

**jgold723** · 5 Jul 2012, 08:59 PM

Originally Posted by dbltoe

NEW-- Was typing while you were typing.... You can also temporarily change their e-mail to yours and send a password that way.

I thought about doing that -- but then I figured that would change their username to my email. Can I change just the email address without affecting the username?

**dbltoe** · 5 Jul 2012, 09:03 PM

Don't think so. And, I should have mentioned that you would want to go down for maintenance while messing with a customer that might be shopping while you're messin'

**DrByte** · 5 Jul 2012, 09:09 PM

More importantly: Can YOU reproduce the problem with your OWN customer account?

Plus, how is the code on your site different from default Zen Cart code? This is important information, since the features you're saying are not working for you do in fact work fine out-of-the-box.

**rhs49010** · 16 Aug 2012, 10:45 PM

Originally Posted by jgold723

I thought about doing that -- but then I figured that would change their username to my email. Can I change just the email address without affecting the username?

I just had the the same issue with the reset email not arriving.
What I had to do was create a customer with the password of password.
After that into phpmyadmin to the customer file and copy and paste the hash into the other customers password location.

Now they can login in and change it to whatever make them happy.