linux下R安装RMySQL不成功 configuration failed for package ‘RMySQL’

ゝ一世哀愁。 2022-06-08 08:37 299阅读 0赞

#install.packages('RMySQL')

报错：  
将程序包安装入‘/home/app\_user\_5i5j/R/x86\_64-pc-linux-gnu-library/3.4’  
(因为‘lib’没有被指定)  
试开URL’[https://mirror.lzu.edu.cn/CRAN/src/contrib/RMySQL\_0.10.13.tar.gz][https_mirror.lzu.edu.cn_CRAN_src_contrib_RMySQL_0.10.13.tar.gz]’

# Content type ‘application/octet-stream’ length 54257 bytes (52 KB) #

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 ‘/home/app\_user\_5i5j/R/x86\_64-pc-linux-gnu-library/3.4/RMySQL’

下载的程序包在  
‘/tmp/RtmpZFkXgl/downloaded\_packages’里  
Warning message:  
In install.packages(“RMySQL”) : 安装程序包‘RMySQL’时退出狀態的值不是0

**解决方式：**  
linux CentOS解决方式  
报错上面提示：没有发现依赖包需要安装  
环境下安装rpm: mariadb-devel | mysql-devel  
\# sudo yum install mariadb-devel  
\# sudo yum install mysql-devel  
然后运行install.packages(‘RMySQL’)安装成功

[https_mirror.lzu.edu.cn_CRAN_src_contrib_RMySQL_0.10.13.tar.gz]: https://mirror.lzu.edu.cn/CRAN/src/contrib/RMySQL_0.10.13.tar.gz