Friday, September 21, 2012

Connect R to a MAMP MySQL Database 

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

4 comments:

  1. DarklesslyJuly 10, 2014 at 9:35 PM

    This has helped me greatly!! Thank you!

    ReplyDelete
  2. B. LanceSeptember 10, 2015 at 5:38 PM

    Thanks! For some reason I had to swap "MySQL" for MySQL(). Probably due to some change since 2011

    ReplyDelete
  3. Andrew KnightSeptember 14, 2015 at 9:39 AM

    Thanks for the comment and letting me know -- I haven't tried it in some time!

    ReplyDelete
  4. UnknownNovember 11, 2015 at 2:24 PM

    Yeah thanks for the help =) the same remark, it should be MySQL() instead of "MySQL"

    ReplyDelete

Subscribe to: Post Comments (Atom)