Facebook Pixel

R, Shiny and MySQL Integration Template

This example shows how to use AnyChart library with the R programming language, Shiny web framework and MySQL database.
View on GitHub


To use this sample you must have R installed, if not you can visit official R site or follow these instructions; MySQL installed and running, if not please check out MySQL download page and follow these instructions.

To check your installations, run the following command in the command line:

$ R --version
R version 3.3.2 (2016-10-31) -- "Sincere Pumpkin Patch"... # sample output

$ mysql --version
mysql  Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6. # sample output

To start this example run commands listed below.

Clone the repository from github.com:

$ git clone git@github.com:anychart-integrations/r-shiny-mysql-template.git

Navigate to the repository folder:

$ cd r-shiny-mysql-template

Set up MySQL database, use -u -p flags to provide username and password:

$  mysql < database_backup.sql

Run R:

$ R

Install application dependencies, one after another and init Shiny:

> install.packages("shiny")

> install.packages("RMySQL")

> install.packages("jsonlite")

> library(shiny)

If you have some troubles with dependencies installation, carefully read error messages, e.g. to install 'RMySQL' you may need:

sudo apt-get install libmysqlclient-dev

Run application supplying absolute path to project folder:

> runApp("{PATH_TO_TEMPLATE}") # e.g. runApp("~/work/r-shiny-mysql-template")

Your browser will open the appliation automatically.


Your workspace should look like:

            style.css       # css style
    app.R                   # main application code
    database_backup.sql     # MySQL database dump
    index.html          # html template


Further Learning


AnyChart R/Shiny/MySQL integration sample includes two parts:

  • Code of the integration sample that allows to use Javascript library (in this case, AnyChart) with R language, Shiny web framework and MySQL database. You can use, edit, modify it, use it with other Javascript libraries without any restrictions. It is released under Apache 2.0 License.
  • AnyChart JavaScript library. It is released under Commercial license. You can test this plugin with the trial version of AnyChart. Our trial version is not limited by time and doesn't contain any feature limitations. Check details here.

If you have any questions regarding licensing - please contact us. sales@anychart.com