connecting to local mariaDB database

[cawthm]

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)}

[technocrat]

You have a missing driver statement

drv <- dbDriver("MySQL")
con <- dbConnect(drv, username="root", password="", dbname ="YOUR_DB_HERE", host="localhost")

[cawthm]

Hmmm. RMariaDB::MariaDB() was being passed to DBI::dbConnect as the driver in my original example, but it doesn't seem to work.

Your advice does, however, so thank you; maybe it's an issue with the MariaDB package for now.

[tbradley]

Hi @cawthm!

If your question's been answered, would you mind choosing a solution? It helps other people see which questions still need help, or find solutions if they have similar problems. Here’s how to do it:

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …

[cawthm]

Done. In this case my question wasn’t really answered since the behavior isn’t really explained and I wanted to let the question sit open for a minimum of 12 hours in case anyone else had anything enlightening to add.

But I guess I should now take that up on the github repo with the maintainers.