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