ubuntu mysql 出错_安装RMySQL时出错(Ubuntu 14.04中的MySQL 5.5.37)

每次我尝试安装R

MySQL我得到以下错误：

Installing package into ‘/home/ehsan/R/x86_64-pc-linux-gnu-library/3.0’

(as ‘lib’ is unspecified)

* installing *source* package ‘RMysqL’ ...

** package ‘RMysqL’ successfully unpacked and MD5 sums checked

checking for gcc... gcc

checking for C compiler default output file name... a.out

checking whether the C compiler works... yes

checking whether we are cross compiling... no

checking for suffix of executables...

checking for suffix of object files... o

checking whether we are using the GNU C compiler... yes

checking whether gcc accepts -g... yes

checking for gcc option to accept ANSI C... none needed

checking how to run the C preprocessor... gcc -E

checking for compress in -lz... yes

checking for getopt_long in -lc... yes

checking for MysqL_init in -lMysqLclient... yes

checking for egrep... grep -E

checking for ANSI C header files... yes

checking for sys/types.h... yes

checking for sys/stat.h... yes

checking for stdlib.h... yes

checking for string.h... yes

checking for memory.h... yes

checking for strings.h... yes

checking for inttypes.h... yes

checking for stdint.h... yes

checking for unistd.h... yes

checking MysqL.h usability... no

checking MysqL.h presence... no

checking for MysqL.h... no

configure: creating ./config.status

config.status: creating src/Makevars

** libs

gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/MysqL/MysqL.h -fpic -O3 -pipe -g -c RS-DBI.c -o RS-DBI.o

cc1: warning: /usr/include/MysqL/MysqL.h: not a directory [enabled by default]

gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I/usr/include/MysqL/MysqL.h -fpic -O3 -pipe -g -c RS-MysqL.c -o RS-MysqL.o

cc1: warning: /usr/include/MysqL/MysqL.h: not a directory [enabled by default]

In file included from RS-MysqL.c:22:0:

RS-MysqL.h:32:19: fatal error: MysqL.h: No such file or directory

#include

^

compilation terminated.

make: *** [RS-MysqL.o] Error 1

ERROR: compilation Failed for package ‘RMysqL’

* removing ‘/home/ehsan/R/x86_64-pc-linux-gnu-library/3.0/RMysqL’

The downloaded source packages are in

‘/tmp/RtmpTRRPqg/downloaded_packages’

Warning message:

In install.packages("RMysqL") :

installation of package ‘RMysqL’ had non-zero exit status**

看来,它找不到MysqL.h,我搜索并更改了路径

export PKG_CPPFLAGS=”-I/usr/R/include/MysqL/MysqL.h”

但却没有成功.有很多人遇到同样的问题,但没有解决方案(如果存在)对我有用.我会感谢任何意见或帮助.

更新：已解决问题

以下命令似乎解决了这个问题：

sudo apt-get install r-cran-rMysqL