Install Database Drivers

RStudio Professional Database Drivers

The RStudio Pro Database Drivers are installed on-demand by the RStudio IDE. Doing so requires internet connectivity.

To test this, start RStudio and invoke the New Connection dialog from the Connections pane.

New Connection Button on Connections Pane Toolbar

The New Connection dialog shows the available database drivers.

New Connections Dialog Showing Database Drivers

Select one, such as MySQL. RStudio first offers to install or update the necessary packages for database connectivity (unless previously installed). These packages apply to all database drivers, so this step will only happen once.

Dialog Asking Permission to Install Database Connectivity Packages

Proceed, and the packages will download and install.

Installing Database Packages Progress Dialog

Once packages are installed, the prompt for installation of the database driver itself will appear.

Dialog Asking Permission to Install a Database Driver

On Windows, each driver needs to make changes to the registry, and will require administrator access.

Windows User Account Control Dialog

Registry Editor Asking Permission to Modify Registry

Finally, the database connection can be configured by the user. On subsequent attempts to create a connection with this driver, RStudio will go straight to this screen.

Dialog for Creating a Connection with a Database Driver