连接到UCSC Genome MYSQL:“无法连接到数据库”

时间:2021-11-16 09:45:59

I loaded the RMySQL package in R. Then tried to run the following :

我在R中加载了RMySQL包。然后尝试运行以下代码:

ucscDb <- dbConnect(MySQL(),user="genome",host="genome=mysql.cse.ucsc.edu")

Output I get :

输出我得到:

Failed to connect to database: Error: Unknown MySQL Server Host 'genome=mysql.cse.ucsc.edu' (11001)

无法连接到数据库:错误:未知的MySQL服务器主机'genome = mysql.cse.ucsc.edu'(11001)

Need help bypassing this error. Is the server down or is something wrong in the code? Thanks.

需要帮助绕过此错误。服务器是否已关闭或代码中出现了问题?谢谢。

1 个解决方案

#1


1  

host="genome=mysql.cse.ucsc.edu" looks like an odd name for a host. Try

host =“genome = mysql.cse.ucsc.edu”看起来像是主机的奇怪名称。尝试

ucscDb <- dbConnect(MySQL(),user="genome",host="genome-mysql.cse.ucsc.edu")

its a dash rather than an equals sign: see here: https://genome.ucsc.edu/goldenPath/help/mysql.html

它是一个短划线而不是一个等号:见这里:https://genome.ucsc.edu/goldenPath/help/mysql.html

#1


1  

host="genome=mysql.cse.ucsc.edu" looks like an odd name for a host. Try

host =“genome = mysql.cse.ucsc.edu”看起来像是主机的奇怪名称。尝试

ucscDb <- dbConnect(MySQL(),user="genome",host="genome-mysql.cse.ucsc.edu")

its a dash rather than an equals sign: see here: https://genome.ucsc.edu/goldenPath/help/mysql.html

它是一个短划线而不是一个等号:见这里:https://genome.ucsc.edu/goldenPath/help/mysql.html