I am about 3 days trying to resolve this problem without sucess.
I have a SQL Server hosted in AWS Amazon. I use PHP MyAdmin to acess the server normally.
Now, I'm trying to connect R Studio with my SQL
install.packages("RMySQL") library(DBI) library(RMySQL) con = dbConnect (MySQL(), dbname = "aaaaaa", host = "[52.67.xx.xxx]", user = "root", password = "xxxxxxx" )
Error in .local(drv, ...) : Failed to connect to database: Error: Can't connect to MySQL server on '[52.67.xx.xxx](http://52.67.xx.xxx/)' (0)
I already tried to put Port 3306 without sucess;
I have already added my own IP on the group security on the Instance AWS;