Thanks for your return.
Thus, when using in the R console the following code:
con1 <- dbConnect(RMySQL::MySQL(),
dbname = "company",
host = "courses.csrrinzqubik.us-east-1.rds.amazonaws.com",
port = 3306,
user = "student",
password = "datacamp"
)
The connection to the db is well established. However when integrated to shiny it doesn't work. I think the inputs type is not recognized. (MySQL db connection info are right)
Here is the ui, where I think inputs are exactly named:
ui <- shinyUI(
dashboardPage(
dashboardHeader(),
dashboardSidebar(),
dashboardBody(
# inputs
box(
textInput("nameDbi", "Db name :"),
textInput("hostDbi", "Db host :"),
numericInput("portDbi","Server port", value = 1000, min = 1, max = 10000),
textInput("userNameDbi", "Login :"),
passwordInput("passWordDbi", "Password :", value = ""),
checkboxInput("check","Check to connect :")),
# outputs
box(tableOutput("table"))
)
)
)
Loaded packages:
library(shinydashboard)
library(shiny)
library(DBI)
library(RMySQL)
library(pool)