title: Connecting to a remote database using RMySQL - access denied
body: <p>I am trying to connect to a remote mysql database by the following steps</p>
  
  <ol>
  <li><code>SSH</code> into their machine and keep the tunnel open
  then,</li>
  <li><p>Using a SQL client (Sequel Pro) or <code>RMySQL</code> through <code>RStudio</code>
  Using the SQL client I can connect to their database and perform queries. However, using <code>RMySQL</code> when I try to connect via,</p>
  
  <pre><code>mydb = dbConnect(dbDriver("MySQL"), user='uname', password='pwd', dbname='dbname', host='localhost',group='destination')
  </code></pre></li>
  </ol>
  
  <p>I am getting the following error, </p>
  
  <blockquote>
    <p>Error in .local(drv, ...) :    Failed to connect to database: Error:
    Access denied for user 'uname'@'localhost' (using password: YES)</p>
  </blockquote>
  
  <p>Help would be appreciated.</p>