List:General Discussion« Previous MessageNext Message »
From:Jeff Kilbride Date:February 28 2003 11:25pm
Subject:Re: mysql encripted password from perl
View as plain text  
How about:

my $sql = "INSERT INTO apidbusers VALUES (?, password(?))";

--jeff

----- Original Message -----
From: "Jianping Zhu" <zjp@stripped>
To: <mysql@stripped>
Sent: Friday, February 28, 2003 2:48 PM
Subject: Re: mysql encripted password from perl


> sth->execute($username, password($password1)) does not work.
>
> On Fri, 28 Feb 2003, Jianping Zhu wrote:
> >
> > I have perl code like
> >    my $username = $query->param("username");
> >    my $password1 = $query->param("password1");
> >    my $sql= "INSERT INTO apidbusers ";
> >       $sql .=  "VALUES(?, ?)";
> >
> >     $sth->execute($username, $password1);
> >    In this way, password1 will be in mysql table as plain text.
> > how can i let it appear in mysql table as encripted?
> >
> > 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 <mysql-thread133708@stripped>
> > To unsubscribe, e-mail
<mysql-unsubscribe-zjp=arches.uga.edu@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> --------------------------------
> Jianping Zhu
> Department of Computer Science
> Univerity of Georgia
> Athens, GA 30602
> Tel 706 5423900
> --------------------------------
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread133712@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-jeff=kilbride.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
what is the best way to check if primary key exists?Jianping Zhu20 Feb
  • Re: what is the best way to check if primary key exists?1LT John W. Holmes20 Feb
    • where shoud i put sql scriptJianping Zhu27 Feb
      • is there a better way to store comments in mysql table?Jianping Zhu27 Feb
  • Re: what is the best way to check if primary key exists?Roger Baklund20 Feb
Re: where shoud i put sql scriptPaul DuBois27 Feb
  • mysql encripted password from perlJianping Zhu28 Feb
    • Re: mysql encripted password from perlJianping Zhu28 Feb
      • Re: mysql encripted password from perlJeff Kilbride1 Mar
        • Can't load data infile ...says :" ...(Using password: YES)"Cl. Yuri Huitron Alvarado1 Mar
          • Re: Can't load data infile ...says :" ...(Using password: YES)"Paul DuBois1 Mar
    • Re: mysql encripted password from perlKH Chiu1 Mar
      • List commandsLda Dominio2 Mar
        • RE: mysql not replicatingDan Rossi2 Mar
Re: is there a better way to store comments in mysql table?Paul DuBois27 Feb
  • Re: is there a better way to store comments in mysql table?Jianping Zhu27 Feb
  • Re: is there a better way to store comments in mysql table?Paul DuBois27 Feb
Re: is there a better way to store comments in mysql table?Paul DuBois27 Feb