open_conn_mysql {dabr}

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)