从R连接到MySQL [英] Connecting to MySQL from R
本文介绍了从R连接到MySQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试从R连接到MySQL.我已经在计算机上安装了"8.0.11 MySQL Community Server-GPL".在R studio中,我已经安装了RMySQL库.
I am trying to connect to MySQL from R. I have installed "8.0.11 MySQL Community Server - GPL" on my machine. In R studio, I have installed RMySQL Library.
当我发出命令时:
con = dbConnect(RMySQL::MySQL(),user="root", password = "password", dbname="test")
我不断收到错误消息:
.local(drv,...)中的错误:无法连接到数据库:错误: 未知的数据库测试"
Error in .local(drv, ...) : Failed to connect to database: Error: Unknown database 'test'
我不确定为什么会一直出现此错误.有什么建议吗?
I am not sure why it keep giving this error. Any suggestions?
推荐答案
这是我用于从R访问MySQL的代码
Here is a code I use for access to MySQL from R
# 1. Library
library(RMySQL)
# 2. Settings
db_user <- 'your_name'
db_password <- 'your_password'
db_name <- 'database_name'
db_table <- 'your_data_table'
db_host <- '127.0.0.1' # for local access
db_port <- 3306
# 3. Read data from db
mydb <- dbConnect(MySQL(), user = db_user, password = db_password,
dbname = db_name, host = db_host, port = db_port)
s <- paste0("select * from ", db_table)
rs <- dbSendQuery(mydb, s)
df <- fetch(rs, n = -1)
on.exit(dbDisconnect(mydb))
请检查它在您身边的工作方式.
Please, check how it works on your side.
PS.好像您错过了"db_table"参数.
PS. Looks like you miss 'db_table' parameter.
这篇关于从R连接到MySQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文