title: AWS EC2 RDS R Shiny - Could not find function DBI::dbFetch()
body: <p>I have an AWS EC2 Ubuntu instance and an AWS RDS MySQL instance. I have connected the two so that my Ubuntu instance can interface with my MySQL database. I have tested the connection and it works. The reason I have done this is so that I can publish a Shiny app for querying my database.</p>
  
  <p>I have installed the prerequisite packages, <code>DBI</code> and <code>RMySQL</code> on my EC2 instance and have called them appropriately in the script. However, I get the error message <code>could not find function "dbFetch"</code> when running the app.</p>
  
  <p>I know something is weird about this because the same script runs on my local. First thing I did was go into my instance's version of R to test out the function. I got the same error message. So I downloaded the DBI package from Github after which the function worked in its R. However, even after rebooting the server, my script returns the same error.</p>
  
  <p>My server.app looks like this:</p>
  
  <pre><code>library(shiny)
  library(DBI)
  library(RMySQL)
  
  server &lt;- function(input, output) {
    db &lt;- dbConnect(MySQL(),
                    dbname = "isi490",
                    host = "isi490.cse8ifih4f0f.us-east-2.rds.amazonaws.com",
                    port = 3306,
                    user = "user",
                    password = "password")
    output$table &lt;- renderTable({
      res &lt;- dbSendQuery(db, input$query)
      dbFetch(res)
    })
  }
  </code></pre>