Can any one please help me to figure out the error caching_sha2_password while trying to connect to remote MySQL database. I was able to establish connection using ODBC driver and checking the option enable cleartext authentication and used the driver name. But I don't want to use the odbc driver as I wanted to deploy the this application to the RStudio Connect , there it wont be possible to install the odbc driver. I am not aware of . Please find the below snippet I used and I used .cnf for credentials.
DBI::dbConnect(RMySQL::MySQL(),group = mysql.congroup, default.file = path.expand(mysql.confile))
Appreciate your help. Thanks