Important note 1: The installation works when using MySQL for 32bit computers and R for 32bit computers. I have tried to install it to the 64bit version of R but I did not succeed.
- Install RTools
- Install MySQL or header and library files of mysql
- Create or edit file
C:\Program Files\R\R-2.12.1\etc\Renviron.siteand add two lines like
- Copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies.
- Copy libmysql.dll to
C:\Program Files\R\R-2.12.1\binor to
install.packages('RMySQL',type='source')and wait while compilation will end.
I solved the problem in the following way. I changed the environment variable TMP to another local folder without containing any accent.
After the installation I rolled back the change in the environment variable.