Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Want to Re-Use Old Password

  1. 06-28-2012, 05:27 PM #1
    Tom Cox is offline Senior Member
    Join Date
    Nov 2009
    Location
    Los Angeles, CA
    Posts
    104

    Default Want to Re-Use Old Password

    I reset my password in ML8.1 and now I realize that I want to use that same password because I have WSI scripts that access several of our sites using that same password.

    Is there any way I can reset the password back to the old password that I used previously? Can I delete a record somehwhere and not break anything?

    Thanks,
    Tom
  2. 06-29-2012, 08:37 PM #2
    ssgumby is offline Senior Member
    Join Date
    Feb 2009
    Posts
    683

    Default

    Yes, this can be done if you have access to your db. Run the SQL below, change "your new paddword here" to your old password and change "your admin email address here" to your email.



    UPDATE [Customer]
    SET [Password] = 'your new password here',
    [SaltKey] = -1,
    [LockedUntil] = DateAdd(mi, -1, GetDate()),
    [BadLoginCount] = 0,
    [PwdChangeRequired] = 0,
    [PwdChanged] = GetDate()
    WHERE [Email] = 'your admin email address here'