Hello Peers ,
I have downloaded MYSQL docker image . Now trying to connect to MYSQL using host given in the IPaddress section of Docker inspect (say “172.17.0.2” ), port 3306 , username :root , and database : mysql.
I am trying to run an R script , where in I have placed the following Database connection ::
con <- dbConnect(RMySQL::MySQL(), dbname = “mysql”, host=“172.17.0.2”, port=3306,
username = “root”, password = )
But getting error , stating the host does not exist.
I even tried using various options of host like “localhost”. But still failing to connect stating ,
Error in .local(drv, …) :
Failed to connect to database: Error: Can’t connect to MySQL server on ‘172.17.0.2’ (0)
Calls: dbConnect -> dbConnect -> .local -> .Call
Please help on this , ASAP.