title: Connecting R-Studio with MySQL leads to errors (Windows)
body: <p>I used this guide: <a href="https://stackoverflow.com/questions/5223113/using-mysql-in-r-for-windows">Using MySQL in R for Windows</a> but it didn't help. I'm already searching for hours on this problem. Since I can't figure out my problem I just can send here the log when trying to <code>install.packages('RMySQL',type='source')</code></p>
  
  <pre><code>&gt; Warning in install.packages :   package ‘RMySQL’ is not available (for
  &gt; R version 3.0.2) Installing package into ‘C:/Users/Mr.
  &gt; Kox/Documents/R/win-library/3.0’ (as ‘lib’ is unspecified) trying URL
  &gt; 'http://cran.rstudio.com/src/contrib/RMySQL_0.9-3.tar.gz' Content type
  &gt; 'application/x-gzip' length 165363 bytes (161 Kb) opened URL
  &gt; downloaded 161 Kb
  &gt; 
  &gt; * installing *source* package 'RMySQL' ...
  &gt; ** Paket 'RMySQL' erfolgreich entpackt und MD5 Summen überprüft
  &gt;       0 [main] sh 6324 find_fast_cwd: WARNING: Couldn't compute FAST_CWD pointer.  Please report this problem to the public mailing
  &gt; list cygwin@cygwin.com checking for $MYSQL_HOME... C:/xampp/mysql
  &gt; cygwin warning:   MS-DOS style path detected: C:/xampp/mysql  
  &gt; Preferred POSIX equivalent is: /cygdrive/c/xampp/mysql   CYGWIN
  &gt; environment variable option "nodosfilewarning" turns off this warning.
  &gt; Consult the user's guide for more details about POSIX paths:
  &gt;     http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
  &gt; ** libs Warnung: this package has a non-empty 'configure.win' file, so building only the main architecture
  &gt; 
  &gt;       0 [main] make 6988 find_fast_cwd: WARNING: Couldn't compute FAST_CWD pointer.  Please report this problem to the public mailing
  &gt; list cygwin@cygwin.com cygwin warning:   MS-DOS style path detected:
  &gt; C:/PROGRA~1/R/R-30~1.2/etc/x64/Makeconf   Preferred POSIX equivalent
  &gt; is: /cygdrive/c/PROGRA~1/R/R-30~1.2/etc/x64/Makeconf   CYGWIN
  &gt; environment variable option "nodosfilewarning" turns off this warning.
  &gt; Consult the user's guide for more details about POSIX paths:
  &gt;     http://cygwin.com/cygwin-ug-net/using.html#using-pathnames gcc -m64 -I"C:/PROGRA~1/R/R-30~1.2/include" -DNDEBUG -I"C:/xampp/mysql"/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
  &gt; [-Wunused-but-set-variable] gcc -m64
  &gt; -I"C:/PROGRA~1/R/R-30~1.2/include" -DNDEBUG -I"C:/xampp/mysql"/include    -I"d:/RCompile/CRANpkg/extralibs64/local/include"     -O2 -Wall  -std=gnu99 -mtune=core2 -c RS-MySQL.c -o RS-MySQL.o RS-MySQL.c: In function 'RS_MySQL_fetch': RS-MySQL.c:657:13: warning: variable
  &gt; 'fld_nullOk' set but not used [-Wunused-but-set-variable] RS-MySQL.c:
  &gt; In function 'RS_DBI_invokeBeginGroup': RS-MySQL.c:1137:30: warning:
  &gt; variable 'val' set but not used [-Wunused-but-set-variable]
  &gt; RS-MySQL.c: In function 'RS_DBI_invokeNewRecord': RS-MySQL.c:1158:20:
  &gt; warning: variable 'val' set but not used [-Wunused-but-set-variable]
  &gt; RS-MySQL.c: In function 'RS_MySQL_dbApply': RS-MySQL.c:1219:38:
  &gt; warning: variable 'fld_nullOk' set but not used
  &gt; [-Wunused-but-set-variable] gcc -m64 -shared -s -static-libgcc -o
  &gt; RMySQL.dll tmp.def RS-DBI.o RS-MySQL.o C:/xampp/mysql/bin/libmySQL.dll
  &gt; -Ld:/RCompile/CRANpkg/extralibs64/local/lib/x64 -Ld:/RCompile/CRANpkg/extralibs64/local/lib -LC:/PROGRA~1/R/R-30~1.2/bin/x64 -lR collect2: ld returned 5 exit status ERROR: compilation failed for package 'RMySQL'
  &gt; * removing 'C:/Users/Mr. Kox/Documents/R/win-library/3.0/RMySQL'
  &gt; * restoring previous 'C:/Users/Mr. Kox/Documents/R/win-library/3.0/RMySQL' Warning in install.packages : 
  &gt; running command '"C:/PROGRA~1/R/R-30~1.2/bin/x64/R" CMD INSTALL -l
  &gt; "C:\Users\Mr. Kox\Documents\R\win-library\3.0"
  &gt; C:\Users\MRFFAF~1.KOX\AppData\Local\Temp\RtmpCGe2RS/downloaded_packages/RMySQL_0.9-3.tar.gz'
  &gt; had status 1 Warning in install.packages :   installation of package
  &gt; ‘RMySQL’ had non-zero exit status
  &gt; 
  &gt; The downloaded source packages are in     ‘C:\Users\Mr.
  &gt; Kox\AppData\Local\Temp\RtmpCGe2RS\downloaded_packages’
  </code></pre>
  
  <p>I think the main problem is in "collect2: ld returned 5 exit status". Well maybe you guys can help me out. Overall I just want to connect R-Studio with a MySQL database. Thanks.</p>