[R-SIG-Finance] RFC: quantmod::getSymbols.MySQL

[Mark Knecht]

On Wed, Oct 29, 2014 at 7:36 AM, Mark Knecht <markknecht at gmail.com> wrote:
> On Wed, Oct 29, 2014 at 6:38 AM, Zachary Deane-Mayer
> <zach.mayer at gmail.com> wrote:
>> Hi Mark,
>>
>> It'd be a little cumbersome, but couldn't you also source() an R script at
>> the start of your session that loads the parameters from .my.cnf and passes
>> them to options()?
>>
>> Alternatively, maybe getSymbols.MySQL could look for a cnf_file option, and
>> then if that is not present look for a username and password?
>>
>> -Zach
>
> Hi Zach & Josh,
>    Yes, I'm sure there's lots of ways to do this, and as an individual
> user just working by myself I'll be happy for anything that works.
>
>    That said, the nice security feature about the way it was done
> before was TTBOMK the R environment never saw the MySQL username &
> password.

I've gone back and looked at my code only to find that R has never
TTBOMK looked at .my.cnf. I've confused this whole thing with an
earlier request that never gained traction.

My apologies for the noise.

- Mark