0

I am trying to install RMySQL package in R, by install.packages("RMySQL"), but it complains that it couldn't find the include libraries. 

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.

So, then I installed mysql in Ubuntu as follows:

sudo apt-get install mysql-client

This installation worked fine, but still I get the same error in R. Can someone point me to the right direction please?

Improve this question
6
  • have you installed RMySQL dependencies (DBI)? Commented Apr 25, 2014 at 0:12
  • I did after reading your comment, but still I have the same issue, and can't install RMySQL. Commented Apr 25, 2014 at 0:34
  • dpkg -l|grep libmysqlclient what outputs? Commented Apr 25, 2014 at 0:39
  • The output is two lines: Commented Apr 25, 2014 at 0:43
  • ii libmysqlclient18 5.5.37-0ubuntu0.12.04.1 MySQL database client library Commented Apr 25, 2014 at 0:43

1 Answer 1

Reset to default
1

I've checked this

http://packages.ubuntu.com/search?keywords=r-cran-rmysql

so you should have r-cran-rmysql package inside your Ubuntu packages list. Therefore

  • from inside R remove DBI, RMySQL packages,
  • then sudo apt-get install r-cran-rmysql

HTH

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.