Skip to main content


Showing posts from December, 2014

Installing RMySQL on OS X "Yosemite"

Here are the instructions to install RMySQL on OS X "Yosemite": Download and install the MySQL community server for OS X . You will need a free Oracle account to complete the download. At the time of this blog post, I installed mysql-5.6.22-osx10.9-x86_64 via the DMG archive. By default MySQL will be installed in /usr/local/mysql-5.6.22-osx10.8-x86_64 (if you use a different version, look for an equivalently named directory under /usr/local). Download sources for the RMySQL package from CRAN . At the time of this blog post, I downloaded RMySQL_0.9-3.tar.gz . Open a Terminal window and run: export DYLD_LIBRARY_PATH=/usr/local/mysql-5.6.22-osx10.8-x86_64/lib:$DYLD_LIBRARY_PATH You may want to consider adding this line to .bashrc as well. In the same terminal window compile and install RMySQL using this command (in a single line): R CMD INSTALL --configure-args="--with-mysql-dir=/usr/local/mysql-5.6.22-osx10.8-x86_64 --with-mysql-inc=/usr/local/mysql-5.6.22-osx10.8