From: Ahmon Dancy

Subject: Re: lisp-mysql connection password encryption?

Date: 2003-10-1 12:06

>> Hello All, >> I have ACL 6.2 connecting to Mysql, but do not want to have my user >> password showing in plain text in the Lisp code. Does anyone have any >> ideas as to how to accomplish this?
You could have the program ask for the password at runtime: (format t "Please enter your password: ") (let ((password (read-line))) (connect :host "myhostname" :user "myusername" :password password :database "test") ...) Similarly, if you didn't want to ask at runtime all the time, you could read the password out of a file in a similar way: (let (password) (with-open-file (f "secrets") (setf password (read-line f))) (connect :host "myhostname" :user "myusername" :password password :database "test") ...) [Make sure the security permissions on file 'secrets' are set properly]. Good luck.
>> >> The command that I use to connect: >> (connect :host "myhostname" :user "myusername" :password "mypass" >> :database "test") >> >> This works just fine, but anyone who can see the code can see the >> password...not good. >> >> Any help is appreciated, >> Christine