dbConnect,MySQLDriver-method

0th

Percentile

Connect/disconnect to a MySQL DBMS

These methods are straight-forward implementations of the corresponding generic functions.

Usage
# S4 method for MySQLDriver
dbConnect(drv, dbname = NULL, username = NULL,
  password = NULL, host = NULL, unix.socket = NULL, port = 0,
  client.flag = 0, groups = "rs-dbi", default.file = NULL, ...)

# S4 method for MySQLConnection dbConnect(drv, ...)

# S4 method for MySQLConnection dbDisconnect(conn, ...)

Arguments
drv

an object of class MySQLDriver, or the character string "MySQL" or an MySQLConnection.

dbname

string with the database name or NULL. If not NULL, the connection sets the default daabase to this value.

username,password

Username and password. If username omitted, defaults to the current user. If password is ommitted, only users without a password can log in.

host

string identifying the host machine running the MySQL server or NULL. If NULL or the string "localhost", a connection to the local host is assumed.

unix.socket

(optional) string of the unix socket or named pipe.

port

(optional) integer of the TCP/IP default port.

client.flag

(optional) integer setting various MySQL client flags. See the MySQL manual for details.

groups

string identifying a section in the default.file to use for setting authentication parameters (see MySQL).

default.file

string of the filename with MySQL client options. Defaults to \$HOME/.my.cnf

...

Unused, needed for compatibility with generic.

conn

an MySQLConnection object as produced by dbConnect.

Aliases
  • dbConnect,MySQLConnection-method
  • dbConnect,MySQLDriver-method
  • dbDisconnect,MySQLConnection-method
Examples
# NOT RUN {
# Connect to a MySQL database running locally
con <- dbConnect(RMySQL::MySQL(), dbname = "mydb")
# Connect to a remote database with username and password
con <- dbConnect(RMySQL::MySQL(), host = "mydb.mycompany.com",
  user = "abc", password = "def")
# But instead of supplying the username and password in code, it's usually
# better to set up a group in your .my.cnf (usually located in your home
directory). Then it's less likely you'll inadvertently share them.
con <- dbConnect(RMySQL::MySQL(), group = "test")

# Always cleanup by disconnecting the database
dbDisconnect(con)
# }
# NOT RUN {
# All examples use the rs-dbi group by default.
if (mysqlHasDefault()) {
  con <- dbConnect(RMySQL::MySQL(), dbname = "test")
  summary(con)
  dbDisconnect(con)
}
# }
Documentation reproduced from package RMySQL, version 0.10.16, License: GPL-2

Community examples

Looks like there are no examples yet.