I've recently installed MariaDB on my Macbook using the brew package installer.
I'm able to connect to a db client session locally via a terminal (and likewise create/ query tables, etc), but am having a tough time connecting to the db from my R session in RStudio
I'm using the RMariaDB package found at this github repo.
Any advice on why I can't create this connection in R is much appreciated.
library("RMariaDB") library("DBI") con <- DBI::dbConnect(RMariaDB::MariaDB(), username="root", password="", dbname ="test", host="localhost") DBI::dbWriteTable(con, 'cars', mtcars, overwrite = T) DBI::dbListTables(con) #> Error in result_fetch(res@ptr, n = n): Error fetching buffer:
Created on 2018-11-29 by the reprex package (v0.2.1)