title: Trying to use R with MySQL: The used command is not allowed with this MySQL version
body: <p>I am trying import a data set into a table in MySQL.  I am using MySQL 8.0.11 and version 1.1.453 of R Studio.  I am using the RMySQL package.</p>
  
  <p>The line in question is:</p>
  
  <pre><code>dbWriteTable(ajppDb, value = EvanData, row.names = FALSE, name = "summaryfile2015", append = TRUE ) 
  </code></pre>
  
  <p>and I get this response:</p>
  
  <p>Error in .local(conn, statement, ...) : 
    could not run statement: The used command is not allowed with this MySQL version</p>
  
  <p>This line worked for me in version 5.7 of MySQL but not for the newer version so I'm not sure what has changed or what I am doing wrong. Does anyone know how I can import my data using R?</p>