Mac R 连接 MySQL

• 安装
  安装RMySQL包时报错
  tar: Failed to set default locale
  解决：在R控制台里运行下面命令，在重新打开R

system('defaults write org.R-project.R force.LANG en_US.UTF-8')

参考：http://stackmirror.caup.cn/page/3xysh3tfepl

• 连接mysql

con <- dbConnect(MySQL(), dbname = "数据库名字", username="root", password="密码",host="localhost", port=3306)

报错
Error in .local(drv, …) :
Failed to connect to database: Error: Plugin caching_sha2_password could not be loaded: dlopen(lib/mariadb/plugin/caching_sha2_password.so, 2): image not found

解决
在MySQLWorkBench里面修改密码

ALTER USER 'root'@'localhost'
IDENTIFIED WITH mysql_native_password BY '785092298Zz';

参考
https://stackoverflow.com/questions/54099722/how-to-connect-r-to-mysql-failed-to-connect-to-database-error-plugin-caching
https://www.jb51.net/article/142025.htm