Erick Stohr writes:
> Hello, I am using the password('mypassword') function to store
> passwords, my question now is how do I pull the password un-encrypted?
> Is that possible? Just looking for the SQL SELECT statement. Running
> MySQL ofcourse. Thanks.
Nope. Like Bob said, password() is a one-way encryption.
If you're looking for two-way to use in your application, check out
the encode()/decode() duo.
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
You have to then make sure to keep the encoding password secure.
Regards,
Matt
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Matt Wagner <mwagner at mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor
/_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA
<___/ www.mysql.com