rmysql-error:无法初始化未知字符集

1tuwyuhd 于 2021-06-20 发布在 Mysql

关注(0)|答案(1)|浏览(739)

正在尝试从r连接到mysql:

library(RMySQL)
mydb<-dbConnect(MySQL(), user='root', password='123', dbname='mydb', host='localhost')

获取以下错误：

Error in .local(drv, ...) : Failed to connect to database: 
Error: Can't initialize character set unknown (path: compiled_in)

使用

R ver is 3.3.3
MySQL is '8.0.12'
default_character_set_name in MySQL is utf8mb4

1条答案

我在安装mysql 8.0.19时也遇到了同样的问题，解决方案是为mysql服务器定位并打开my.cnf和set字符集。

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci