How to require SSL in RMySQL in R?

Asked Aug 29 '18 at 22:31

Active Aug 29 '18 at 22:31

Viewed 1,184 times

I used to connect to MySQL databases from R with this function:

db <- DBI::dbConnect(RMySQL::MySQL(),
                            user = server$db_user,
                            password = server$db_pw,
                            host = server$host,
                            dbname = db_name)

This function works perfectly fine before. Now after we modified the databases with SSL, it is no longer working. What would be the solution to there?

asked Aug 29 '18 at 22:31

Sharedobe

Try specifying the `sslmode` like in this answer? https://stackoverflow.com/a/33179039/4421870 – Mako212 Aug 29 '18 at 22:35
Are you getting any specific error? – msr_003 Aug 30 '18 at 08:55

How to require SSL in RMySQL in R?

0 Answers0