I am using the following code to connect to a remote MySQL Database. The dbConnect function with con1 runs OK. I can access MySQL and read a table.
When I use con2 there seems to be a connection (at least I do not get an error or warning and after running the disconnect statement the result is TRUE), but when I try to read a table I get:
Error in .local(conn, statement, ...) : could not run statement: No database selected
Anyone any idea why? The code:
library(DBI) con1 <- dbConnect(RMySQL::MySQL(), username = "public1", password = "test", host = "127.0.0.1", port = 3306, dbname = "bitnami_moodle" ) mycnf <- file.path("c:","Users","NB","my.cnf") con2 <- dbConnect(RMySQL::MySQL(), default.file = mycnf, group = "client") dbReadTable(conn = con, name = "mdl_user") dbDisconnect(con)
The content of my.cnf is:
[client] user = public1 password = test host = 127.0.0.1 port = 3306 dbname = bitnami_moodle