I am testing connecting to MySQL using R on Ubuntu 20.04 and keep getting the following error when using RMySQL.
It works when using the native mysql client.
Error in R:
Loading required package: DBI Error in .local(drv, ...) : Failed to connect to database: Error: SSL connection error: SSL_CTX_set_default_verify_paths failed Calls: dbConnect -> dbConnect -> .local -> .Call Execution halted
Any guidance would be appreciated.