Re: Converting password to old format.

2006-03-24 Thread Ady Wicaksono
AFAIK, PASSWORD() or OLD_PASSWORD() is one way function, it means in math if you do f(x) = y, you never know x, all you now is the result of f(x) ~ y Moreover, do you have a problem with new password format? Eugene Kosov wrote: Hi, everyone! I have transfer user's database and grants

Re: Converting password to old format.

2006-03-24 Thread Eugene Kosov
Yes I know restoring plain password from it's hash is impossible (at least in theory ;)) but I don't need password itself. I thought if we know f1(x) (PASSWORD) and f2(x) (OLD_PASSWORD) we possibly can get such f(x) that will make expression f2(x) = f(f1(x)) truth for every x. I haven't

Re: Converting password to old format.

2006-03-24 Thread Ady Wicaksono
Sorry, I have no idea about that :) Eugene Kosov wrote: Yes I know restoring plain password from it's hash is impossible (at least in theory ;)) but I don't need password itself. I thought if we know f1(x) (PASSWORD) and f2(x) (OLD_PASSWORD) we possibly can get such f(x) that will make

Converting password to old format.

2006-03-23 Thread Eugene Kosov
Hi, everyone! I have transfer user's database and grants from one mysql server (4.1.15) to an older one (4.0.26). I don't know user's password and have only it's hash. How can I convert hashed password stored in mysql.user.password field to the 4.0 format? Is there something similar to

Re: Converting password to old format.

2006-03-23 Thread SGreen
Eugene Kosov [EMAIL PROTECTED] wrote on 03/23/2006 07:03:15 AM: Hi, everyone! I have transfer user's database and grants from one mysql server (4.1.15) to an older one (4.0.26). I don't know user's password and have only it's hash. How can I convert hashed password stored in