I’m trying to connect to my database via R (a statistical programming language). I’m running the script from my computer (not my server), and I’ve added my ip to accepted hosts. When I run the code
con<-dbConnect(m,user="username", password="pw", host="hostname", dbname="db")
I get the following error:
Error in .local(drv, ...) :
Failed to connect to database: Error: Can't connect to MySQL server on 'mysql.ahubers.com' (0)
I have ran code similar to this before without issues on separate databases (not hosted by dreamhost), so I’m wondering if someone else has accessed their db like this or has an idea for what to try? It feels like my changes to accepted hosts isn’t going through (I’ve tried adding wild cards to both ends of my ip).