src_mysql_from_cnf: Helper function: store MySQL database credentials in...

In KWB-R/kwb.pilot: Importing, Aggregating and Visualising Data From KWB Pilot Plants

Helper function: store MySQL database credentials in ".my.cnf"

Description

Helper function: store MySQL database credentials in ".my.cnf"

Usage

src_mysql_from_cnf(
  dbname,
  group = NULL,
  dir = file.path(getwd(), ".my.cnf"),
  host = NULL,
  user = NULL,
  password = NULL,
  ...
)

Arguments

dbname	name of database to be accessed
group	name of group
dir	path to the MySQL configuration file (default: file.path(getwd(), ".my.cnf"))
host	hostname of MySQL database (default: NULL)
user	username of MySQL database (default: NULL)
password	password of MySQL database (default: NULL)
...	further arguments passed to dplyr::src_mysql()

Value

sets dplyr::src_mysql to work with MySQL config file

KWB-R/kwb.pilot documentation built on Nov. 1, 2022, 2:49 p.m.