RMySQL

RMySQL is a database interface and MySQL driver for R that implements the DBI specification, allowing R users to connect to MySQL databases and execute SQL queries. This package is being phased out in favor of the newer RMariaDB package.

The package provides a complete implementation of the DBI interface for MySQL, enabling standard database operations like connecting to databases, reading and writing tables, executing queries, and fetching results in chunks. It supports MySQL configuration files for secure credential management and works across multiple platforms including Linux, macOS, and Windows. The implementation offers better compatibility when linked against MariaDB Connector/C rather than Oracle’s legacy libmysqlclient driver.