Ubuntu下R安装MySQL驱动
ubuntu 14.04
参考:
http://blog.fens.me/r-mysql-rmysql/
正常情况下:
install.packages("RMySQL")
如果安装不报错,
library(RMySQL)正常,就成功了。
下边说出现异常的安装:
下载依赖包:
https://cran.r-project.org/web/packages/DBI/index.html
Package source: DBI_0.5.tar.gz
下载RMySQL包:
在https://cran.r-project.org/web/packages/RMySQL/index.html
Package source: RMySQL_0.10.9.tar.gz
安装
root@py-11:/# R CMD INSTALL DBI_0.5.tar.gz
root@py-11:/# R CMD INSTALL RMySQL_0.10.9.tar.gz
如果没报错,命令行输入
R
进入R后,
library(RMySQL)正常,就成功了。
如果有以下报错
==================================================
downloaded 52 Kb
* installing *source* package ‘RMySQL’ ...
** 成功将‘RMySQL’程序包解包并MD5和检查
Using PKG_CFLAGS=
Using PKG_LIBS=-lmysqlclient
------------------------- 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=...'
--------------------------------------------------------------------
ERROR: configuration failed for package ‘RMySQL’
ubuntu 14.04
参考:
http://blog.fens.me/r-mysql-rmysql/
正常情况下:
install.packages("RMySQL")
如果安装不报错,
library(RMySQL)正常,就成功了。
下边说出现异常的安装:
下载依赖包:
https://cran.r-project.org/web/packages/DBI/index.html
Package source: DBI_0.5.tar.gz
下载RMySQL包:
在https://cran.r-project.org/web/packages/RMySQL/index.html
Package source: RMySQL_0.10.9.tar.gz
安装
root@py-11:/# R CMD INSTALL DBI_0.5.tar.gz
root@py-11:/# R CMD INSTALL RMySQL_0.10.9.tar.gz
如果没报错,命令行输入
R
进入R后,
library(RMySQL)正常,就成功了。
如果有以下报错
==================================================
downloaded 52 Kb
* installing *source* package ‘RMySQL’ ...
** 成功将‘RMySQL’程序包解包并MD5和检查
Using PKG_CFLAGS=
Using PKG_LIBS=-lmysqlclient
------------------------- 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=...'
--------------------------------------------------------------------
ERROR: configuration failed for package ‘RMySQL’