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 any problem with new password format, I just have to move some databases from one server to another.



Ady Wicaksono wrote:
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 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 OLD_PASSWORD(), but with 4.1's hashed password as a parameter?

Any links, man references, etc. are welcome!

Thanks in advance!

--
Regards,
Eugene Kosov.





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to