Thanks guys, Cristian also suggested that I could encrypt the password via the porgramming language I use with mysql(php,perl,etc). How could this be done? I am using the struts framework. JSPs and Java.
Does this mean that I can only use md5()? cheers, Ki Mien -----Original Message----- From: "MikeParton" <[EMAIL PROTECTED]> Sent: Sunday, July 07, 2002 3:43 AM To: "MikeParton" <[EMAIL PROTECTED]>, "Ki Mien" <[EMAIL PROTECTED]>, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Subject: Re: encrypting password fields oops....that's my Apache version. I am using MySQL 4.0.1 and have used md5() with MySQL 3.23.49-max-nt ----- Original Message ----- From: "MikeParton" <[EMAIL PROTECTED]> To: "Ki Mien" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, July 06, 2002 3:02 PM Subject: Re: encrypting password fields > I have MySQL 2.0.39 on Win NT and I use md5() to create a digest of the > password. Perhaps not the highest level of password encryption, but works > for the level of security I need. > > > ----- Original Message ----- > From: "Ki Mien" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, July 06, 2002 4:16 AM > Subject: encrypting password fields > > > Hi mySql gurus, > > I have a table that contains my customers username and password. I would > like to know how I can encrypt these values so that they are not stored how > in the way that my customers have keyed them from the front end. > > I have read the documentation on password(), and encrypt but it won't work > as I am using windows os and mysql version 3.23.49-max-nt-log. > > I appreciate any help on this. > > cheers, > Ki Mien > > ------------------------------------------------------------------------ > cOntact @ Lycos <http://contact.lycosasia.com> > = 10MB for email and filestore + lots of other goodies... > > --------------------------------------------------------------------- > 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 > > ------------------------------------------------------------------------ Take part in the Penning on Squares Chinese Essay Writing Contest. Submit your masterpieces or vote for your favourite works, and win attractive prizes. Be there or be SQUARE! http://sea.litcontest.lycosasia.com cOntact @ Lycos <http://contact.lycosasia.com> = 10MB for email and filestore + lots of other goodies... --------------------------------------------------------------------- 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
