How to de-crypt password(password)???

[arpizt]

i have create 1 field password(type = password).
The problem is.. How i want to know what is the password..
incase i want to change it or see it value... The value is look like "2c34e9217ed0e185". Pls help me..

[Wiedmann]

Not possible.

BTW:
Never use this SQL-Statement for own tables. Use this only for MySQL user passwords.

[Dr.Miles]

the value like "2c34e9217ed0e185" is the md5-hash of the password. The onliest known way to get back it is to create md5 hashes of all possible passwords nd compare it with the value in the field. this is called "brute force" if you know parts of the passwords its more successful. else it can use many years.... you can too try to make a dictionary-attack.
I think it is too much work for your case, but maybe anotehr person who read this it is successful.
I too wanted to correct Wiedmann, he has in mostly reality right, but sometimes not. And if it is a simple password then the way i descriped is successful...

greetz - Dr.Miles

[DBMark]

I think it is too much work for your case, but maybe anotehr person who read this it is successful.

There is a project to build up MD5 hashes and to reverse engineer the original uncrypted word. Try entering your MD5 hash here ----
http://md5.rednoize.com/
Of course, the more successful that project is, the less secure will be your MD5 encryption process. There are ways around this (using the "salting" method or combining hashes etc). A very good discussion on this at the php manual site at :
http://de.php.net/md5

[guw]

i have create 1 field password(type = password).
The problem is.. How i want to know what is the password..
incase i want to change it or see it value... The value is look like "2c34e9217ed0e185". Pls help me..

You could just create a second field, NOT of the type password and save the unencrypted password text there - if you have access to it.