List:General Discussion« Previous MessageNext Message »
From:Sudheer Satyanarayana Date:August 18 2007 12:23pm
Subject:Re: Password storage
View as plain text  
C K wrote:
> Friends,
> I have one question - How to store passwords in MySQL database table in a
> secure way so that no one can see the password(understand the password
> string)?
> Please help
> Thanks
> CPK
>
>   
mysql> create table test01 (pass varchar(32));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into test01 values (md5('textpassword'));
Query OK, 1 row affected (0.01 sec)

mysql> select * from test01;
+----------------------------------+
| pass                             |
+----------------------------------+
| d1c7e2c37b0bb7d92548ac5594d00315 |
+----------------------------------+
1 row in set (0.00 sec)


The md5 function encrypts the input string.

---------
With Warm Regards,
Sudheer. S
www.binaryvibes.co.in
www.lampcomputing.com

Thread
Password storageC K18 Aug
  • Re: Password storageYoge18 Aug
  • Re: Password storageSudheer Satyanarayana18 Aug
    • Re: Password storageC K18 Aug
      • Re: Password storageMogens Melander18 Aug
        • Re: Password storageMike Aubury18 Aug
          • Re: Password storageMogens Melander18 Aug
      • Re: Password storageSudheer Satyanarayana18 Aug
      • Re: Password storageMichael Dykman20 Aug
        • mysql errorCharles Brown20 Aug
          • Re: mysql errorMichael Dykman20 Aug
          • Re: mysql errorMike Zupan20 Aug
  • Re: Password storageDavid T. Ashley19 Aug