[thelist] md5 hashed password problem
Anthony Baratta
anthony at baratta.com
Wed Aug 15 12:57:45 CDT 2007
Hassan - package this as a "tip" so the search engines can get it!!
-----Original message-----
From: "Hassan Schroeder" hassan.schroeder at gmail.com
Date: Wed, 15 Aug 2007 10:46:31 -0700
To: bobm at dottedi.biz, "thelist at lists.evolt.org" thelist at lists.evolt.org
Subject: Re: [thelist] md5 hashed password problem
> So, out of curiousity --
>
> > > | old_passwords | ON |
> /
> > I don't know if that variable is global or can be changed on, say, a
> > per-connection basis;
>
> I tried a quick experiment, and it appears that you /can/ set this on a
> per-connection basis. So all you have to do is flag the moved-over
> users as 'uses_old_passwords', and then when one of them logs in,
> do a SET OLD_PASSWORDS="OFF" before the password comparison.
>
> Yes, ugly and annoying, and why the heck anyone'd have MySQL set
> up with the old password format at this point is beyond me, but there
> is at least a workaround...
>
> HTH!
> --
> Hassan Schroeder ------------------------ hassan.schroeder at gmail.com
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list