Getting error while connecting to mysql Error: Failed to connect: Plugin caching_sha2_password could not be loaded: The specified module could not be found.

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 :frowning:. 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

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.