Category: Code

Connect R to a MAMP MySQL Database

Code, by andrew, September 21, 2012 


# NOTE: Edited since originally published due to a change in R...<br />require(RMySQL)<br />con &lt;- dbConnect(MySQL(), username="{USERNAME}", host="localhost", dbname="{DATABASE}", password="{PASSWORD}", unix.sock="/Applications/MAMP/tmp/mysql/mysql.sock")<br />res <- code="" con="" dat="" dbsendquery="" fetch="" from="" res=""><br /></->