I store my password to database after encryption using PASSWORD() function
mysql_query("INSERT INTO 'table' (`id`,`username`,`pass`) VALUES('','".$_POST['username']."',PASSWORD('".$_POST['pass']."'))");

I stored successfully, and by Phpmyadmin, I see that password was encrypted. the password I stored was 123456 and I see it is like 7dc963da69c.... (this encryption password generated by me, not by mysql)

now I want to get back my originial password, i.e. 123456 by mysql_query statement.

Pls. tell how I can get it back

Best Regard:
Md. Zakir Hossain (Raju)
www.rubd.net
www.xenex.rubd.net
www.forum.rubd.net

__________________
Best Regard:
Md. Zakir Hossain (Raju)

www.rajuru.xenexbd.com - my blog with PHP scripts, PHP Book Review and many more

Read: http://dev.mysql.com/doc/mysql/en/en...functions.html

Quotes:

"PASSWORD() encryption is one-way (not reversible)."

"The PASSWORD() function is used by the authentication system in MySQL Server, you should not use it in your own applications. For that purpose, use MD5() or SHA1() instead. Also see RFC 2195 for more information about handling passwords and authentication securely in your application."

Basically, always _hash_ passwords, instead of encrypt them. That means that it's impossible to find the original value of the password (yes, you can find other plain texts that give the same hash, but there's no guarantee that it's the original password (although apparently 2 plaintexts giving the same hash is _extremely_ rare)).

Hope this helps

Cheers
--Colin

--
Please contact me at:
Colin (dot) Horne (at) gmail (dot) com
My blog: http://colinhorne.blogspot.com