Re: lisp-mysql connection password encryption?

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