title: Acces denied MariaDB Amazon-rds instance RMySQL and OBDC (windows)
body: <p>I'm trying to connect R with my MariaDB instance (10.0 - Amazon RDS). Connection works fine in HeidiSQL. Both in R and ODBC drivers installation (direct and indirect), next error is prompted:</p>
  
  <pre><code>Error in .local(drv, ...) : 
    Failed to connect to database: Error: Access denied for user 'user'@'localhost' (using password: YES)
  </code></pre>
  
  <p>My account is the admin account of this instance, I used the following code:</p>
  
  <pre><code>library(RMySQL)
  
  mySqlCreds &lt;- list(dbhostname = "dbname.rds.amazonaws.com" , dbname="dbnamefull"                 , username = "user",pass = "secret", port = 3306) 
  
  drv &lt;- dbDriver("MySQL")
  
  dbConnect(drv, host=mySqlCreds$dbhostname, dbname=mySqlCreds$dbname, user=mySqlCreds$username, password=mySqlCreds$pass, port = mySqlCreds$port)
  </code></pre>
  
  <p>Same problem while connecting an ODBC driver in Windows to this instance- finds database, but again no access. Even after modifying instance parameter groups in aws console, log_bin_trust_function_creators to 1, and rebooting the database. </p>
  
  <p>If you know how to solve this issue, please let me know! Thank you in advance!</p>