Mamp not connecting to mysql server how to#
Mamp not connecting to mysql server install#

Note: If you restart your machine, you will have to re-run the bash command aboveвЂ¦Not quite sure why that is, but you can probably figure out a more permanent solution. con <- DBI::dbConnect(RMariaDB::MariaDB(), user = Sys.getenv('mysql_user'), password = Sys.getenv('mysql_pass'), host = 'localhost')ДbGetQuery(conn = con, statement = 'show databases ')ДЄwesome! We are connected to our MySQL instance that we installed with MAMP. System('ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock') So what we can do is write a bash command that creates a hard link from the MAMP location to where the RMariaDB package expects it: #either open terminal and run what's within quotes, or run it write from r with the system() function.

Mamp not connecting to mysql server install#

Mine isnвЂ™t there because I used MAMP to install MySQL MAMP places the socket file here: /Applications/MAMP/tmp/mysql/mysql.sock. According to MySQLвЂ™s documentation, Unix systems use this socket file for connecting to MySQL databases. library(tidyverse)Д¬on <- DBI::dbConnect(RMariaDB::MariaDB(), user = Sys.getenv('mysql_user'), password = Sys.getenv('mysql_pass'), host = 'localhost')Д®rror: Failed to connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Mamp not connecting to mysql server how to#

You can learn more on how to do that on RStudioвЂ™s Databases using R page. Since I donвЂ™t want to embed my username and password, I am using environmental variables. Okay, letвЂ™s first see if we can connect to the database. So if you havenвЂ™t done so already, install the following packages (along with nycflights13 which weвЂ™ll be using for a demo): install.packages('tidyverse') I tend to always trust the folks at RStudio for great package development, and this is a part of the DBI interface that in my experience gives the best performance for database work in R. So instead of attempting to set up an ODBC connection to MySQL, I am simply going to use the RMariaDB package coupled with DBI (IвЂ™m skipping the odbc package altogether). Setting up drivers, ODBC connections, and DSN files is difficult enough in Windows, let alone on a Mac. RStudio has a great website that walks through their enterprise packages for working with databases, but IвЂ™ve often found this site confusing. There are lots of different ways to connect to a db in R. This tutorial assumes you have already installed MAMP and have it currently running on your local machine in a macOS environment.