These methods are straight-forward implementations of the corresponding generic functions.
# S4 method for MariaDBDriver dbConnect( drv, dbname = NULL, username = NULL, password = NULL, host = NULL, unix.socket = NULL, port = 0, client.flag = 0, groups = "rs-dbi", default.file = NULL, ssl.key = NULL, ssl.cert = NULL, ssl.ca = NULL, ssl.capath = NULL, ssl.cipher = NULL, ..., bigint = c("integer64", "integer", "numeric", "character"), timeout = 10, timezone = "+00:00", timezone_out = NULL ) MariaDB()
string with the database name or NULL. If not NULL, the connection sets the default database to this value.
Username and password. If username omitted, defaults to the current user. If password is omitted, only users without a password can log in.
string identifying the host machine running the MariaDB server or
NULL. If NULL or the string
(optional) string of the unix socket or named pipe.
(optional) integer of the TCP/IP default port.
(optional) integer setting various MariaDB client flags, see Client-flags for details.
string identifying a section in the
string of the filename with MariaDB client options,
only relevant if
(optional) string of the filename of the SSL key file to use.
(optional) string of the filename of the SSL certificate to use.
(optional) string of the filename of an SSL certificate authority file to use.
(optional) string of the path to a directory containing the trusted SSL CA certificates in PEM format.
(optional) string list of permitted ciphers to use for SSL encryption.
Unused, needed for compatibility with generic.
The R type that 64-bit integer types should be mapped to, default is bit64::integer64, which allows the full range of 64 bit integers.
Connection timeout, in seconds. Use
(optional) time zone for the connection,
the default corresponds to UTC.
Set this argument if your server or database is configured with a different
time zone than UTC.
The time zone returned to R.
The default is to use the value of the
MySQL and MariaDB support named time zones, they must be installed on the server. See https://dev.mysql.com/doc/mysql-g11n-excerpt/8.0/en/time-zone-support.html for more details. Without installation, time zone support is restricted to UTC offset, which cannot take into account DST offsets.
Configuration files: https://mariadb.com/kb/en/library/configuring-mariadb-with-mycnf/