setupMariaDB function

Setup database driver and define connection parameters for MariaDB using RMariaDB package. Wrapper for setupDriver() function.

setupMariaDB(
  db,
  host = "127.0.0.1",
  port = "3306",
  dbname = "mydb",
  user = "root",
  password = "password",
  protect = c("password", "user"),
  ...
)

Arguments

• db: rocker object
• host: Host name or IP number
• port: Port number
• dbname: Database name
• user: User name
• password: Password
• protect: Parameters to be hidden
• ...: Optional, additional suitable parameters passed to DBI::dbConnect()

Returns

Invisible self

Examples

db <- rocker::newDB()
rocker::setupMariaDB(
  db,
  host = "127.0.0.1", port = "3306", dbname = "mydb",
  user = "root", password = "password"
)
rocker::unloadDriver(db)

See Also

Other rocker-S3-functions: appendTable(), begin(), canConnect(), clearResult(), columnInfo(), commit(), connect(), createTable(), disconnect(), execute(), existsTable(), fetch(), getInfoCon(), getInfoDrv(), getInfoRes(), getQuery(), getRowCount(), getRowsAffected(), getStatement(), hasCompleted(), isValidCon(), isValidDrv(), isValidRes(), listFields(), listObjects(), listTables(), readTable(), removeTable(), rocker-README, rocker-S3-functions, rocker-package, rollback(), sendQuery(), sendStatement(), setupDriver(), setupPostgreSQL(), setupSQLite(), unloadDriver(), validateCon(), writeTable()