open_conn_mysql: Connect to database

In special-uor/dabr: Database Management with R

Connect to database

Description

Uses RMariaDB to open a connection to a MySQL database.

Usage

open_conn_mysql(
  dbname,
  user = "root",
  password = NULL,
  host = "127.0.0.1",
  port = 3306
)

Arguments

dbname	Database/Schema name.
user	Username of database owner.
password	Password (default: NULL).
host	Database host, it can be local (default) or remote.
port	Database port.

Value

MariaDBConnection connection object.

See Also

Other DB functions: close_conn(), delete(), insert(), list_tables(), select_all(), select(), update()

Examples

## Not run: 
conn <- open_conn_mysql("sys")

## End(Not run)

special-uor/dabr documentation built on Oct. 21, 2022, 3:04 p.m.