title: R connect to MySQL server with enable-cleartext-plugin option
body: <p>I'm trying to connect to remote MySQL server via TCP/IP.
  Server requires mysql-clear-password enabled.
  I use RMySQL library on Kubuntu 16.04 to connect to server, but there is no option other than to configure odbc.ini file to pass the plugin trigger. When running the code I get error</p>
  
  <blockquote>
    <p>Failed to connect to database: Error: Plugin mysql_clear_password
    could not be loaded</p>
  </blockquote>
  
  <p>Is there a way to pass this trigger with RMySQL?</p>