Re: Password storage

2007-08-20 Thread Michael Dykman
If you can't access functions directly, you could implement a trigger on that row to intercept the password as it being written and do your MD5 encoding there. - michael On 8/18/07, C K [EMAIL PROTECTED] wrote: Thanks to all, but the problem is that I am using external programs to insert

Re: Password storage

2007-08-19 Thread David T. Ashley
On 8/18/07, C K [EMAIL PROTECTED] 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)? It is considered bad security practice to store passwords using reversible encryption.

Password storage

2007-08-18 Thread C K
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 -- Keep your Environment clean and green.

Re: Password storage

2007-08-18 Thread Yoge
Use MD5 function to encrypt the password column 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 -- Yoge, AdventNet, Inc. 925-965-6528

Re: Password storage

2007-08-18 Thread Sudheer Satyanarayana
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

Re: Password storage

2007-08-18 Thread C K
Thanks to all, but the problem is that I am using external programs to insert data and I can't use MySQL functions directly. Can I call/implement such type of functions using MS Access 2003? Thanks CPK The md5 function encrypts the input string. - With Warm Regards, Sudheer. S

Re: Password storage

2007-08-18 Thread Mogens Melander
On Sat, August 18, 2007 15:53, C K wrote: Thanks to all, but the problem is that I am using external programs to insert data and I can't use MySQL functions directly. Can I call/implement such type of functions using MS Access 2003? MD5() is not an encryption function. The MySQL manual

Re: Password storage

2007-08-18 Thread Mike Aubury
But you can use it for passwords (ask Unix)... You can't decode what the original password was, but you can encode the password they typed in and check the two hashes match - if they do - the chances are that the original passwords match (the odds against are huge!) On Saturday 18 August

Re: Password storage

2007-08-18 Thread Mogens Melander
On Sat, August 18, 2007 20:17, Mike Aubury wrote: But you can use it for passwords (ask Unix)... You can't decode what the original password was, but you can encode the password they typed in and check the two hashes match - if they do - the chances are that the original passwords match (the

Re: Password storage

2007-08-18 Thread Sudheer Satyanarayana
Hi, What are those external programs? If you are using a scripting language like PHP to insert data, you can still use all the MySQL functions in your query statements. I'm not sure how this is related to MS Access 2003. With Warm Regards, Sudheer. S www.binaryvibes.co.in