If you are using PHP and do not want to pass clear-text passwords over a network to a
remote MySQL server, you can use the crypto
libs in PHP for one-way hashing too (I use MD5, for example).
----- Original Message -----
From: "Philip Mak" <[EMAIL PROTECTED]>
To: "Tom Jones" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, December 29, 2001 11:56 PM
Subject: Re: A password column
> 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
>
>
---------------------------------------------------------------------
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
