Database Interface and 'MySQL' Driver for R
Overview
Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old code ported from S-PLUS. A modern 'MySQL' client written in 'C++' is available from the 'RMariaDB' package.
- Show a hint about MARIADB_TLS_DISABLE_PEER_VERIFICATION when failing to connect.
From NEWS.md in the release
Install
Health
- OK13 OK2026-08-05
- NOTE12 OK, 1 NOTE2026-08-01
- OK12 OK2026-04-25
- WARNING12 OK, 2 WARNING2026-03-10
Documentation
- Help pages
- 24 (5 internal)includes a package overview page
- Examples that run
- 100%15 run in a plain check
- Exported functions with examples
- 78%
- Documented parameters
- 83%
- Return-value docs
- 67%
- Help pages citing references
- 0%
Downloads
Repository
- PRs merged (all time)
- 61%
- Median days to close, 50 most recently updated closed issues
- 434
- Median days to close, 50 most recently updated closed PRs
- 21
Stars over time
Forks over time
Releases over time
Issues over time
PRs over time
8 development-tooling and community-health practices detected across 6 families in the upstream repository
Checks run against github.com/r-dbi/rmysql on 2026-10-18.
The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel
GitHub Pages site last deployed 2017-10-26
Show all practicesHide 2 practices
Dependencies
Installing RMySQL adds 1 package (0 with compiled code, 727 KB of source tarballs). Heaviest: DBI 727 KB.
Show all 16 packagesHide all 16 packages
Code & Tests
People & History
Maintainer since 0.10 (2015), previously Jeffrey Horner (0.7-2 to 0.9-3) and David A. James (0.4-2 to 0.6-1)
Show 4 peopleHide 4 people
Pick two releases to compare their code metrics.
- RR 4.6.0 released · 2026-04-24
- 0.11.3Latest
- 0.11.22026-03-02 · diff ↗
- RR 4.5.0 released · 2025-04-11
- 0.11.12025-04-01 · diff ↗
- 0.11.02025-02-08 · diff ↗
- 0.10.292024-10-04 · diff ↗
- 0.10.282024-08-22 · diff ↗
- RR 4.4.0 released · 2024-04-24
- 0.10.272023-12-04 · diff ↗
- 0.10.262023-09-26 · diff ↗
- RR 4.3.0 released · 2023-04-21
- 0.10.252022-12-06 · diff ↗
- 0.10.242022-10-18 · diff ↗
- RR 4.2.0 released · 2022-04-22
- 0.10.232021-12-14 · diff ↗
Show 78 earlier eventsHide 78 earlier events
- 0.10.222021-06-22 · diff ↗
- RR 4.1.0 released · 2021-05-18
- 0.10.212020-12-15 · diff ↗
- RR 4.0.0 released · 2020-04-24
- 0.10.202020-03-14 · diff ↗
- 0.10.192020-02-03 · diff ↗
- 0.10.182019-12-14 · diff ↗
- RR 3.6.0 released · 2019-04-26
- 0.10.172019-03-04 · diff ↗
- 0.10.162019-01-04 · diff ↗
- 0.10.152018-05-13 · diff ↗
- RR 3.5.0 released · 2018-04-23
- 0.10.142018-02-26 · diff ↗
- 0.10.132017-08-14 · diff ↗
- 0.10.122017-07-06 · diff ↗
- RR 3.4.0 released · 2017-04-21
- 0.10.112017-03-29 · diff ↗
- 0.10.102017-03-21 · diff ↗
- 0.10.92016-05-08 · diff ↗
- RR 3.3.0 released · 2016-05-03
- 0.10.82016-01-29 · diff ↗
- 0.10.72015-10-27 · diff ↗
- 0.10.62015-09-05 · diff ↗
- 0.10.52015-08-25 · diff ↗
- 0.10.42015-07-28 · diff ↗
- 0.10.32015-04-21 · diff ↗
- RR 3.2.0 released · 2015-04-16
- 0.10.22015-02-24 · diff ↗
- 0.10.12015-01-15 · diff ↗
- 0.102015-01-05 · diff ↗ ·
removed 25 exports
dbBuildTableDefinition, .MySQLKeywords, mysqlInitDriver, mysqlCloseDriver, mysqlDescribeDriver, mysqlDriverInfo, mysqlNewConnection, mysqlCloneConnection, mysqlDescribeConnection, mysqlConnectionInfo, mysqlCloseConnection, mysqlExecStatement, mysqlQuickSQL, mysqlDBApply, mysqlFetch, mysqlResultInfo, mysqlDescribeResult, mysqlDescribeFields, mysqlCloseResult, mysqlImportFile, mysqlReadTable, mysqlWriteTable, mysqlEscapeStrings, mysqlDataType, safe.writeadded 6 exports
dbApply, dbEscapeStrings, dbMoreResults, dbNextResult, mysqlBuildTableDefinition, mysqlHasDefault - RR 3.1.0 released · 2014-04-10
- RR 3.0.0 released · 2013-04-03
- RR 2.15.0 released · 2012-03-30
- 0.9-32012-01-17 · diff ↗
- 0.9-02012-01-14 · diff ↗
- RR 2.14.0 released · 2011-10-31
- 0.8-02011-06-09 · diff ↗
- RR 2.13.0 released · 2011-04-13
- RR 2.12.0 released · 2010-10-15
- 0.7-52010-07-24 · diff ↗
- RR 2.11.0 released · 2010-04-22
- RR 2.10.0 released · 2009-10-26
- RR 2.9.0 released · 2009-04-17
- 0.7-42009-04-14 · diff ↗
- 0.7-3
- 0.7-22008-12-05 · diff ↗
- RR 2.8.0 released · 2008-10-20
- 0.6-12008-09-08 · diff ↗
- RR 2.7.0 released · 2008-04-22
- RR 2.6.0 released · 2007-10-03
- 0.6-02007-06-01 · diff ↗ ·
added 45 exports
MySQL, dbBuildTableDefinition, isIdCurrent, .MySQLKeywords, mysqlInitDriver, mysqlCloseDriver, mysqlDescribeDriver, mysqlDriverInfo, mysqlNewConnection, mysqlCloneConnection, mysqlDescribeConnection, mysqlConnectionInfo, mysqlCloseConnection, mysqlExecStatement, mysqlQuickSQL, mysqlDBApply, mysqlFetch, mysqlResultInfo, mysqlDescribeResult, mysqlDescribeFields, mysqlCloseResult, mysqlImportFile, mysqlReadTable, mysqlWriteTable, mysqlEscapeStrings, mysqlDataType, safe.write, CLIENT_LONG_PASSWORD, CLIENT_FOUND_ROWS, CLIENT_LONG_FLAG and 15 more - RR 2.5.0 released · 2007-04-24
- 0.5-112007-01-05 · diff ↗
- 0.5-102006-10-27 · diff ↗
- 0.5-92006-10-07 · diff ↗
- RR 2.4.0 released · 2006-10-03
- RR 2.3.0 released · 2006-04-24
- 0.5-72006-01-28 · diff ↗
- RR 2.2.0 released · 2005-10-06
- RR 2.1.0 released · 2005-04-18
- RR 2.0.0 released · 2004-10-04
- 0.5-52004-06-22 · diff ↗
- 0.5-42004-04-13 · diff ↗
- RR 1.9.0 released · 2004-04-12
- 0.5-32003-12-02 · diff ↗
- RR 1.8.0 released · 2003-10-08
- 0.5-22003-05-17 · diff ↗
- RR 1.7.0 released · 2003-04-16
- 0.5-12003-04-07 · diff ↗
- 0.5-02002-10-01 · diff ↗
- RR 1.6.0 released · 2002-10-01
- 0.4-62002-06-27 · diff ↗
- 0.4-52002-05-21 · diff ↗
- RR 1.5.0 released · 2002-04-29
- 0.4-32001-11-06 · diff ↗
- 0.4-22001-03-12 · diff ↗
- 0.2-32000-10-06 · diff ↗
- 0.22000-02-04
Package metadata
- First published
- 2000-02-04
- Total releases
- 59 / 26 yrs
- License
- GPL-2 OSI · relicensed from LGPL version 2 or later in 0.7-2
- Minimum R
- ≥ 2.8.0
- Download size
- 52 KB
Cite
Cite this package
Run in R for the authors' preferred citation:
citation("RMySQL")This package has no citation file, so citation() returns this entry built from DESCRIPTION.
Cite the R Observatory
For a number measured here: a download total, a coverage figure, an archival date.
From data release v2026-10-22, which the citation names so these numbers can be found later. More on citing and the projects behind them.