title: Connecting to MySQL from R
body: <p>I am trying to connect to MySQL from R. I have installed "8.0.11 MySQL Community Server - GPL" on my machine. In R studio, I have installed RMySQL Library.</p>
  
  <p>When I give the command:</p>
  
  <pre><code>con = dbConnect(RMySQL::MySQL(),user="root", password = "password", dbname="test")
  </code></pre>
  
  <p>I keep getting the error:</p>
  
  <blockquote>
    <p>Error in .local(drv, ...) :  Failed to connect to database: Error:
    Unknown database 'test'</p>
  </blockquote>
  
  <p>I am not sure why it keep giving this error. Any suggestions?</p>