Last active
August 16, 2016 18:09
-
-
Save anhqle/bfc58efc3cfe97ef1217 to your computer and use it in GitHub Desktop.
How to install RMySQL on Windows
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ## A Guide on Install RMySQL on Windows | |
| I have encountered various error messages during installation, including | |
| * mysql.h not found | |
| * cygwin path warning | |
| Just install a fresh install of MySQL Server (no need for Workbench and Connector, or anything else). | |
| Here are the steps: | |
| 1. Download MySQL installer (which contains all products) from [here](http://dev.mysql.com/downloads/windows/installer/) | |
| 2. Install MySQL Server using the installer | |
| 3. Follow the official installation guide [here](http://cran.r-project.org/web/packages/RMySQL/INSTALL) | |
| * The key is to set the environment variable either via command from or via Renviron.site like [this guide](http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL) suggests | |
| * [Some answers](http://stackoverflow.com/questions/21363709/how-to-install-rmysql-package-for-windows) mention that `libmysql.dll` is missing from `MySQL\MySQL Server 5.6\bin` and must be copied there. I found that a fresh install of MySQL Server has that by itself. | |
| * The cygwin warning about path also does not apply to a fresh MySQL Server install | |
| ## Note on install MySQL Workbench | |
| If encounter the error `The application was unable to start correctly (0xc000007b)` | |
| * Remove workbench via MySQL Installer | |
| * Download Visual C++ Redistributable Packages FOR 64 BIT | |
| * Reinstall/ Repair Visual C | |
| * Reinstall workbench |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment