xuefliang

library(RMySQL) con <-  dbConnect(RMySQL::MySQL(),                   username = "root",                   password = "123456",                   host = "127.0.0.1",                   port = 3306,                   dbname = "python" ) con <- DBI::dbConnect(odbc::odbc(),                       driver = "/opt/rstudio-drivers/mysql/bin/lib/libmysqlodbc_sb64.so",                       database = "python",                       UID    = "root",                       PWD    = "123456",                       server = "172.17.0.5",                       port = 3306) # con <- dbConnect(odbc::odbc(), "oracledb", UID="samples", #                  PWD= rstudioapi::askForPassword("Samples User Password")) library(DBI) #"MySQL"为/etc/odbc.ini配置的信息 # [MySQL] # Driver=/opt/rstudio-drivers/mysql/bin/lib/libmysqlodbc_sb64.so # DSN=MySQL # Se