The manual suggests that the password function is really for intenal mysql
functions. Ideally you should use the encode or md5_encode functions.
update user set password=encode('password', 'salt') where user =
'your_user';
Curtis
On Wed, 5 Feb 2003, Natale Babbo wrote:
> try to use the password() function.
>
> update user set password=password('your_psw') where
> user='your_user'
>
> bye
>
>
>
>
> --- Jianping Zhu <[EMAIL PROTECTED]> ha scritto: >
> > I have mysql in a redhat machine. I need to use
> > mysql do user
> > authentication to a website.
> > I have a table like following.
> >
> > +----------+----------+
> > | username | passwd |
> > +----------+----------+
> > | jianping | jian1830 |
> > | chichi | jian1830 |
> > +----------+----------+
> >
> > I want the passwd field not to be plain text but
> > encrypted. how can i do
> > that?
> >
> > Thanks.
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > 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
> >
>
> ______________________________________________________________________
> Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino
> http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html
>
> ---------------------------------------------------------------------
> 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
