Connect/disconnect to a MySQL DBMS

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

Usage

# S4 method for class '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 class 'MySQLConnection'
dbConnect(drv, ...)

# S4 method for class '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.

Usage

Arguments

Examples