RMySQL troubleshooting in Ubuntu

Posted by Priyanka Nag on 3:25 AM in , , ,
RMySQL package installation is no longer as easy as it used to be with the previous versions. The simple install.packages("RMySQL") no longer works like a magic! 
If you try this command on your latest R version, you are likely to get the following errors:

Configuration error:
"could not find the MySQL installation include and/or library directories. Manually specify the location of the MySQL libraries and the header files and re-run R CMD INSTALL."

I have found the solution to this problem. You can also try this and see if your problem is being solved.

Some simple steps are:
  • Get mysql-connector-c-6.0.2-linux-glibc2.3-x86-64bit from this link here
  • Un-tar the contents in your downloaded folder.
  • There you will get two folders- 'library' and 'include'.  
  • on your /usr/local/include folder you will need to copy the contents of the 'library' and 'include' folder (copy the contents in the 'include' and 'library' folders respectively). 
  • inside your /usr/local/include folder, you will need to make a new directory "mysql" and there need to run the following commands:
    • cp -R '/home/username/Downloads/mysql-connector-c-6.0.2-linux-glibc2.3-x86-64bit/include/.' '/usr/local/lib64/R/include/.'  
    • cp -R '/home/username/Downloads/mysql-connector-c-6.0.2-linux-glibc2.3-x86-64bit/lib/.' '/usr/local/lib64/R/lib/.'
  •  After this, try the command  R CMD INSTALL MySQL_0.9-3.tar.gz (or whichever version you have downloaded.
  • After all of these processes are done, switch to your R console and try library(RMySQL). If you get the "Loading required package: DBI", your job is done!
You will need to install these other packages as well:
  • sudo apt-get install r-cran-rmysql
  • sudo apt-get install r-cran-dbi
Hope this helps. If there are errors in this or if you have a better solution to this, please share that in comments.


Post a Comment

If you like the blog, you may also want to checkout Priyanka's website