r连接mysql 安装失败_R无法安装RMySQL程序包解决方案

在R的交互环境下利用 install.packages(“RMySQL”)在线安装RMySQL程序包出现如下错误：

> install.packages("RMySQL")

将程序包安装入‘/usr/local/lib/R/site-library’

(因为‘lib’没有被指定)

Warning in install.packages("RMySQL") :

'lib="/usr/local/lib/R/site-library"'不可写

Would you like to use a personal library instead? (y/n) y

Would you like to create a personal library

~/R/x86_64-pc-linux-gnu-library/3.4

to install packages into? (y/n) y

Warning: 无法在貯藏處https://cloud.r-project.org/src/contrib中读写索引:

无法打开URL'https://cloud.r-project.org/src/contrib/PACKAGES'

Warning message:

package ‘RMySQL’ is not available (for R version 3.4.4)

再次尝试，仍然报错，但是提示需要依赖安装DBI程序包。