我昨天将MySQL更新到最新版本8.0.11,并尝试使用RMySQL连接MySQL,但它无法工作,我找不到任何解决方案。
我的代码:
我的代码:
library(RMySQL)
con <- dbConnect(MySQL(), user="hello", password="hi", dbname = "webscrape", host="xx.xxx.xxx.xxx", port=xxxx)
错误:
Error in .local(drv, ...) :
Failed to connect to database: Error: Can't initialize character set unknown (path: compiled_in)