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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
