安装部署（十） Ubuntu下安装R和RMySQL驱动

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’
* removing ‘/usr/local/lib/R/site-library/RMySQL’


下载的程序包在
‘/tmp/Rtmppi4CVK/downloaded_packages’里
警告信息：
In install.packages("RMySQL") : 安装程序包‘RMySQL’时退出狀態的值不是0
> quit()
Save workspace image? [y/n/c]: n


需要安装：
root@py-11:/projects# apt-get install libmariadbclient-dev
正在读取软件包列表... 完成


之后，重新安装RMySQL
root@py-11:/projects# R CMD INSTALL RMySQL_0.10.9.tar.gz
测试。