Helper function: store MySQL database credentials in ".my.cnf"
src_mysql_from_cnf(dbname, group = NULL, dir = file.path(getwd(), ".my.cnf"), host = NULL, user = NULL, password = NULL, ...)
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() |
sets dplyr::src_mysql to work with MySQL config file