/usr/lib/R/site-library/ensembldb/doc/MySQL-backend.R is in r-bioc-ensembldb 2.2.2-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | ## ----eval = FALSE----------------------------------------------------------
# library(ensembldb)
# ## Load the EnsDb package that should be installed on the MySQL server
# library(EnsDb.Hsapiens.v75)
#
# ## Call the useMySQL method providing the required credentials to create
# ## databases and inserting data on the MySQL server
# edb_mysql <- useMySQL(EnsDb.Hsapiens.v75, host = "localhost", user = "userwrite",
# pass = "userpass")
#
# ## Use this EnsDb object
# genes(edb_mysql)
#
## ----eval = FALSE----------------------------------------------------------
# library(ensembldb)
# library(RMySQL)
#
# ## Connect to the MySQL database to list the databases.
# dbcon <- dbConnect(MySQL(), host = "localhost", user = "readonly",
# pass = "readonly")
#
# ## List the available databases
# listEnsDbs(dbcon)
#
# ## Connect to one of the databases and use that one.
# dbcon <- dbConnect(MySQL(), host = "localhost", user = "readonly",
# pass = "readonly", dbname = "ensdb_hsapiens_v75")
# edb <- EnsDb(dbcon)
# edb
#
|