I see this issue has been asked in several places on the internet like this however not of the solutions seem to be working for me.
I have set up a mysql database in AWS however I cannot connect to it using R. This is my code for connecting -
library(tidyverse) library(dplyr) library(RMySQL) con <- DBI::dbConnect( drv = RMySQL::MySQL(), username = Sys.getenv("AWSRDS_USER"), passwords = Sys.getenv("AWSRDS_PASS"), host = Sys.getenv("AWSRDS_HOST"), port = 3306, dbname = "awsrds01" )
I keep getting this error -
Error in .local(drv, ...) : Failed to connect to database: Error: Access denied for user 'xxxx'@'pool-xxx-xx-xx-xx.bltmmd.fios.verizon.net' (using password: NO)
Other info -
Operating system - macOS Monterey (Version 12.5)
R Studio version - 4.0.2 (2020-06-22)
dplyr version - 1.0.9
RMySQL version - 0.10.21
DBI version - 1.1.3
Any help/ideas/suggestions on how to fix this will be much appreciated.