mysql - 将 R 连接到在 Amazon ec2 Ubuntu 计算机上运行的 MySQL 时出错

Question

我最近在我的 Amazon EC2 Ubuntu 计算机上配置了 MySQL。我正在尝试将 MySQL 数据库连接到在同一台计算机上运行的 RStudio。我正在使用 R 包 RMySQL 来实现相同的目的。

我的 R 代码:

library(dbConnect)
library(RMySQL)
con = dbConnect(MySQL(), user='user1', password='pass1', dbname='db1', host='http://ec2-*********.us-west-2.compute.amazonaws.com/')

错误消息:

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.2.22/angular.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/knockout/3.1.0/knockout-min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.4.9/d3.min.js"></script>
    Error in mysqlNewConnection(drv, ...) : 
      RS-DBI driver: (Failed to connect to database: Error: Unknown MySQL server host 'http://ec2-52-24-185-205.us-west-2.compute.amazonaws.com/' (2)

<!-- end snippet -->

Answer 1

您应该能够使用以下命令在 Ubuntu 计算机上连接到 MySQL 数据库:

library("RMySQL")

mySqlCreds <- list(dbhostname = "YourHostIP",
               dbname   = "YourDB",
               username = "YourUserName",
               pass = "YourPassword",
               port = 1111
                 )

drv <- dbDriver("MySQL")
dbConnect(drv, host=mySqlCreds$dbhostname, dbname=mySqlCreds$dbname, 
        user=mySqlCreds$username, password=mySqlCreds$pass, port = mySqlCreds$port)

当然，端口是您或您的 DBA 指定的端口...