On Sat, 29 Dec 2001, Tom Jones wrote:
> I'm fairly new to MySQL and I was wonder if there was a way to, well let's
> say encrypt a password in a column? I would like to have a users table in my
> database and in it I would like to have a password column, but I don't want
> the password in plain text. Is this possible?
Use the PASSWORD() function. Example:
INSERT INTO users VALUES ('pmak', PASSWORD('secret'));
This is a one way hash. I think it works the same way on all MySQL
servers (i.e. it's portable).
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
