I found the install for RMySQL, an R package that links to a MySQL database, somewhat cumbersome. Here were a few things I had to tweak to get it right.
For starters, I was installing using R-2.13.2, RMySQL-0.8-0, and MySQL-5.5
First, you have to specify the path to MySQL:
For me this was: C:\\Program Files\\MySQL\\MySQL Server 5.5, but you must specify it a little bit differently, here is the R command to execute from within Rgui.exe
Next, the R install expects to find a few files (libmysql.dll and libmysql.lib) that in MySQL 5.5 reside in C:\\Program Files\\MySQL\\MySQL Server 5.5\\lib to actually reside in C:\\Program Files\\MySQL\\MySQL Server 5.5\\lib\\opt
To fix this make the subdirectory “opt” and copy the files into that subdirectory
You will also need to copy the file “libmysql.dll” from “C:\\Program Files\\MySQL\\MySQL Server 5.5\\lib” to your R\\bin directory which would be “C:\\Program Files\\R\\R-2.13.2\\bin\\i386″ on 32-bit Windows or on 64-bit Windows “C:\\Program Files\\R\\R-2.13.2\\bin\\x64″, Hat-tip to the following StackOverflow answer.