mysql - Windows 8.1安装RMySQL的另一个错误

Question

我有一台 Windows 8.1 机器并使用 R 3.0.3 和 RTools 30。我正在尝试安装 RMySQL 并按照 http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/ 中的说明进行操作和另一个 StackOverflow 帖子，但我一遍又一遍地收到此错误:

  installing *source* package 'RMySQL' ...
  package 'RMySQL' successfully unpacked and MD5 sums checked
 0 [main] sh 3240 find_fast_cwd: WARNING: Couldn't compute FAST_CWD pointer.  Please report this problem to
 the public mailing list cygwin@cygwin.com
 checking for $MYSQL_HOME... â€C:/Program Files/MySQL/MySQL Server 5.6/â€
 test: Files/MySQL/MySQL: unknown operand
 cygwin warning:
   MS-DOS style path detected: C:/PROGRA~1/R/R-30~1.3/bin/x64/Rscript
   Preferred POSIX equivalent is: /cygdrive/c/PROGRA~1/R/R-30~1.3/bin/x64/Rscript
   CYGWIN environment variable option "nodosfilewarning" turns off this warning.
   Consult the user's guide for more details about POSIX paths:
     http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
  libs
 Warning: this package has a non-empty 'configure.win' file,
 so building only the main architecture

       0 [main] make 4640 find_fast_cwd: WARNING: Couldn't compute FAST_CWD pointer.  Please report this problem to
 the public mailing list cygwin@cygwin.com
 cygwin warning:
   MS-DOS style path detected: C:/PROGRA~1/R/R-30~1.3/etc/x64/Makeconf
   Preferred POSIX equivalent is: /cygdrive/c/PROGRA~1/R/R-30~1.3/etc/x64/Makeconf
   CYGWIN environment variable option "nodosfilewarning" turns off this warning.
   Consult the user's guide for more details about POSIX paths:
     http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
 gcc -m64 -I"C:/PROGRA~1/R/R-30~1.3/include" -DNDEBUG -I"â€C:/Program Files/MySQL/MySQL Server 5.6/â€"/include    -I"d:/RCompile/CRANpkg/extralibs64/local/include"     -O2 -Wall  -std=gnu99 -mtune=core2 -c RS-DBI.c -o RS-DBI.o
 RS-DBI.c: In function 'RS_na_set':
 RS-DBI.c:1219:11: warning: variable 'c' set but not used [-Wunused-but-set-variable]
 gcc -m64 -I"C:/PROGRA~1/R/R-30~1.3/include" -DNDEBUG -I"â€C:/Program Files/MySQL/MySQL Server 5.6/â€"/include    -I"d:/RCompile/CRANpkg/extralibs64/local/include"     -O2 -Wall  -std=gnu99 -mtune=core2 -c RS-MySQL.c -o RS-MySQL.o
 In file included from RS-MySQL.c:22:0:
 RS-MySQL.h:32:19: fatal error: mysql.h: No such file or directory
 compilation terminated.
 make: *** [RS-MySQL.o] Error 1
 Warning: running command 'make -f "Makevars.win" -f "C:/PROGRA~1/R/R-30~1.3/etc/x64/Makeconf" -f "C:/PROGRA~1/R/R-30~1.3/share/make/winshlib.mk" SHLIB="RMySQL.dll" WIN=64 TCLBIN=64 OBJECTS="RS-DBI.o RS-MySQL.o"' had status 2
 ERROR: compilation failed for package 'RMySQL'
  removing 'C:/Users/Yohanan/Documents/R/win-library/3.0/RMySQL'
 Warning in install.packages :
   running command '"C:/PROGRA~1/R/R-30~1.3/bin/x64/R" CMD INSTALL -l "C:\Users\Yohanan\Documents\R\win-library\3.0" C:\Users\Yohanan\AppData\Local\Temp\RtmpysBrc8/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1
 Warning in install.packages :
   installation of package ‘RMySQL’ had non-zero exit status

你能帮帮我吗？谢谢...

Answer 1

可能是您的 MySQL 安装出了问题。

错误是指缺少注册表项，如此处所述: MySQL Manual - MySQL Installation ，搜索 SOFTWARE\MySQL AB 会显示说明注册表应该是什么样子的部分。使用 regedit.exe，您可以自行修复此问题。

关于如何使用 regedit.exe 的信息:Techsupportalert - Regedit in One Easy Lesson

它对我解决了同样的问题