Re: password encryption - lei shen - com.mysql.lists.perl

5 messages in com.mysql.lists.perlRe: password encryption

From	Sent On	Attachments
Subramanyam Malepati	20 May 2004 02:23
lei shen	20 May 2004 05:01
Jochen Wiedmann	20 May 2004 06:17
lei shen	24 May 2004 05:22
Greg Meckes	24 May 2004 15:03

Subject:	Re: password encryption
From:	lei shen (lsh...@pop900.gsfc.nasa.gov)
Date:	05/24/2004 05:22:02 AM
List:	com.mysql.lists.perl

dose mysql or any other database has function like Oracle NOLOG option? thanks

Brian

lei shen wrote:

Hi! Dose anyone know how to encryption the password in perl? i do not want to show the database password in my file. thank you very much.

As you need to encrypt and decrypt the password, you would typically need some kind of "key". However, to perform the decryption, access to the key is required. So you end up with the same problem: How to protect the key?

A typical solution for the problem is to store the credentials in a separate file with proper permissions. For example, if root is running the program in question, then one would use a file readable by root only.