title: Use sqldf in R - cannot specify correct username
body: <p>I just downloaded <code>R</code> package called <code>sqldf</code> just for fun, but have not been able to run it correctly so far. When I try to do some query using <code>iris</code> datasets:</p>
  
  <pre><code>sqldf("select * from iris limit 5")
  </code></pre>
  
  <p>the error occurred saying <code>Error in mysqlNewConnection(drv, ...) : 
    RS-DBI driver: (Failed to connect to database: Error: Access denied for user 'myUserName'@'localhost' (using password: NO)
  )
  Error in !dbPreExists : invalid argument type</code></p>
  
  <p>So I opened its help documentation and then run the following query:</p>
  
  <pre><code>sqldf("select * from iris limit 5", user="myUser")
  </code></pre>
  
  <p>the error message is the same as the above, which would mean that I failed to specify my <code>user</code> argument correctly, given that the error message doesn't change to <code>Access denied for user 'myUser'@'localhost')</code>.</p>
  
  <p>So how can I fix it and run it correctly?</p>
  
  <p>For your information when I use <code>RMySQL</code>, I use the following arguments in order to make connection.</p>
  
  <pre><code>con &lt;- dbConnect(dbDriver("MySQL"),username="myUser",password="myPass",host="myHost",unix.sock="/tmp/mysql.sock",dbname="myDB")
  </code></pre>
  
  <p>I'm on OS X 10.9.1 and use MySQL 5.6 installed via homebrew, and R version 3.0.2 and sqldf version 0.4-6.</p>
  
  <p>Thanks.</p>