Question: How to install a bioconductor package RMySQL and specify R parameters
gravatar for mousheng xu
17 days ago by
mousheng xu10
mousheng xu10 wrote:

I am trying to install CopywriteR, which failed at updating a dependent package RMySQL. The error I got was as follows:

------------------------- ANTICONF ERROR ---------------------------

Configuration failed because libmysqlclient was not found. Try installing:

 * deb: libmariadb-client-lgpl-dev (Debian, Ubuntu 16.04)

        libmariadbclient-dev (Ubuntu 14.04)

 * rpm: mariadb-devel | mysql-devel (Fedora, CentOS, RHEL)

 * csw: mysql56_dev (Solaris)

 * brew: mariadb-connector-c (OSX)

If libmysqlclient is already installed, check that 'pkg-config' is in your

PATH and PKG_CONFIG_PATH contains a libmysqlclient.pc file. If pkg-config

is unavailable you can set INCLUDE_DIR and LIB_DIR manually via:

R CMD INSTALL --configure-vars='INCLUDE_DIR=... LIB_DIR=...'


My question is: where can I specify  --configure-vars='INCLUDE_DIR=... LIB_DIR=...'? I cannot do this at command line because RMySQL is installed through bioconductor. If I do

 R CMD INSTALL --configure-vars='INCLUDE_DIR=/mydir/mariadb-connector-c' RMySQL

I will get:


Warning: invalid package ‘RMySQL’

Error: ERROR: no packages specified


Thanks in advance!

ADD COMMENTlink modified 16 days ago by shepherl ♦♦ 510 • written 17 days ago by mousheng xu10
gravatar for shepherl
16 days ago by
shepherl ♦♦ 510
shepherl ♦♦ 510 wrote:

When you run R CMD INSTALL --configure-vars='INCLUDE_DIR=/mydir/mariadb-connector-c' RMySQL , you need to be in a directory where RMySQL is present. So you can download the package here and then run or be in the directory whereever a local copy is.

ADD COMMENTlink written 16 days ago by shepherl ♦♦ 510
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.2.0
Traffic: 103 users visited in the last hour