Mass password change

[360themes]

I have imported around 14thousands members on 26 Feb 2007. However, there are too many of them who cannot use their old passwords.
Is there any query which i can execute to make a mass password change for all members registered on 26.02.07 to a default password.
I am really having trouble with this problem. Really appreciate any help. Tks you guys so much!

[Mickie D]

im not sure if i am 100% right here but i think you have upgraded mysql and it uses a new password method (something on this line)

i think you can make the new mysql recognise old passwords

im sure i did this myself and got the info from

vbulletin.com

only a suggestion

[jason|xoxide]

Originally Posted by Mickie D

im not sure if i am 100% right here but i think you have upgraded mysql and it uses a new password method (something on this line)

i think you can make the new mysql recognise old passwords

im sure i did this myself and got the info from

vbulletin.com

only a suggestion

vBulletin does not use the MySQL password() function, so a version change would not be an issue unless your new version has different character sets than the old version.

I believe that the passwords are stored as "md5(md5(password)+salt)". If that's the case, yes, it would be pretty easy to change a bunch of passwords all at once.

[xinnek]

can some one tell me the steps to do this?

[Opserty]

Whoops didn't see the post date...