Technically MD5/SHA1 are hashing algorithms and shouldn't be confused with encryption
algorithms like DES, 3DES or AES. From the looks of the document link you gave us it
seems that AES_ENCRYT is the way to go if you want to encrypt the data.
So the command would look something like this:
INSERT INTO t VALUES (1,AES_ENCRYPT("text","password"));
So are you saying that the XXX_ENCRYPT function isn't to be used?
> -----Original Message-----
> From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2003 3:41 PM
> To: [EMAIL PROTECTED]
> Cc: 'Mysql'
> Subject: Re: Can we crypt passwords on MySQL
>
> It's not recommended because in MySQL 4.1, it returns a different result
> each time PASSWORD() is used, with the same input string.
> For MD5/SHA1 function, take a look here :
>
> http://www.mysql.com/doc/en/Miscellaneous_functions.html
>
> Jocelyn
>
>
>
>
> ----- Original Message -----
> From: "development" <[EMAIL PROTECTED]>
> To: "'Jocelyn Fournier'" <[EMAIL PROTECTED]>
> Cc: "'Mysql'" <[EMAIL PROTECTED]>
> Sent: Thursday, June 19, 2003 12:38 AM
> Subject: RE: Can we crypt passwords on MySQL
>
>
> Jocelyn
>
> Why is that not recommended ?
>
> Do you have any links for how to encrypt the password with MD5 ?
>
> Freddie
>
>
> -----Original Message-----
> From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]
> Sent: Freitag, 27. Juni 2003 00:19
> To: [EMAIL PROTECTED]; Grégoire Dubois
> Cc: 'Mysql'
>
> Hi,
>
> Using PASSWORD function to crypt password is not recommended, it's mainly
> used for internal mysql password encryption.
> Prefer using MD5/SHA1 functions to encrypt a password.
>
> Regards,
> Jocelyn
>
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: "Grégoire Dubois" <[EMAIL PROTECTED]>
> Cc: "'Mysql'" <[EMAIL PROTECTED]>
> Sent: Thursday, June 19, 2003 12:14 AM
> Subject: RE: Can we crypt passwords on MySQL
>
>
> > There is a PASSWORD('your_clear_text_password_here') function you can
> use
> > wherever you define a new password. See the manual for more.
> >
> > Lian
> >
> >
> > > -----Original Message-----
> > > From: Grégoire Dubois [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, June 19, 2003 12:55 AM
> > > Cc: 'Mysql'
> > > Subject: Can we crypt passwords on MySQL
> > >
> > >
> > > Hi all,
> > >
> > > Is it possible to crypt the passwords on MySQL. If yes, how does it
> > > work, and how is it to be implemented.
> > > Any link would be great.
> > >
> > > Thank you.
> > > Grégoire Dubois.
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> pc.com
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
