CODEWITHSUNDEEP
mysqldatabaserdatabase-connection
Alex
Alex

Reputation: 19883

connecting to database using RMySQL, R and MySQL

I am trying to connect to my database from R. When I start the server from the shell (using unix), i have to pass the --ssl-ca=myfile. How do I pass this flag using the dbConnect function? Thanks.

Upvotes: 3

Views: 1558

Answers (1)

Alex
Alex

Reputation: 19883

Problem solved. Create a file in some directory and in that file write the following:

[client]
password=yourpass
username=yourusername
...
ssl-ca=yourcertspath

Then pass the file name to the default.file param of dbConnect

Upvotes: 6

Related Questions