RFC: quantmod::getSymbols.MySQL
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