Connect to database — open_conn_mysql • dabr

Uses RMariaDB to open a connection to a MySQL database.

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

if (FALSE) {
conn <- open_conn_mysql("sys")
}