Working through a R Studio Community Topic in regards to connecting R studio to an AWS DB instance using an SSH tunnel.
Original Post:
Currently getting: Error in connection_create(host, username, password, dbname, as.integer(port), :
Failed to connect: Can't connect to MySQL server on 'XXX' (0)
Outside of R Studio I am able to connect to the DB through an SSH tunnel and not seeing any issues. Inside R studio running into the error with the same credentials and setup. Looking to see if anyone has any thoughts on creating more robust logging to see where in the process things are getting hung up?
Running both the R studio and the working MySql Workbench on a Windows 10 machine.