Password storage

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

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 [EMAIL

Re: Password storage

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> ins

Re: Password storage

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.

Re: Password storage

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 st

Re: Password storage

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 200

New Value From Concatenated Values?

Is there a way to update a table so that a column's values can be changed to a concatenation of two other column values? For instance, something like ... UPDATE TABLE tablename SET colA = colB.colC; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Recreate Table With Sorted Data

Embarrassingly simple answer to the question why I didn't just use a View ... I haven't gotten to that chapter in the manual yet. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: New Value From Concatenated Values?

Kebbel, John wrote: Is there a way to update a table so that a column's values can be changed to a concatenation of two other column values? For instance, something like ... UPDATE TABLE tablename SET colA = colB.colC; Is this what you're looking for? mysql> create table concattest (

Re: Password storage

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

Re: Password storage

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 www.lampcomputing.co

Re: New Value From Concatenated Values?

Your solution was exactly what the doctor ordered. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]