{"repo":"r-dbi/RMySQL","free":true,"listed":false,"github":"https://github.com/r-dbi/RMySQL","clone":"git clone https://github.com/r-dbi/RMySQL.git","description":"Legacy DBI interface for MySQL","language":"C","stars":208,"topics":["r","database","mysql"],"license":null,"category":"databases-storage","readme_excerpt":"RMySQL ====== NOTE: this package is being phased out in favor of the new RMariaDB package. Database Interface and MySQL Driver for R RMySQL is a database interface and MySQL driver for R. This version complies with the database interface definition as implemented in the package DBI 0.2-2. Hello World Installation Binary packages for OS-X or Windows can be installed directly from CRAN: The development version from github: Installation from source on Linux or OSX requires MariaDB Connector/C . On some older platforms you can also link against Oracle's libmysqlclient driver but the mariadb implementation is much better. On recent Debian or Ubuntu install libmariadbclient-dev On Fedora , CentOS or RHEL we need mariadb-devel: On OS-X use mariadb-connector-c from Homebrew: MySQL configuration file Instead of specifying a username and password in calls to dbConnect() , it's better to set up a MySQL configuration file that names the databases that you connect to most commonly. This file should live in /.my.cnf and look like: If you want to run the examples, you'll need to set the proper options in the [rs-dbi] group of any MySQL option file, such as /etc/my.cnf or the .my.cnf file in your home directory. For a default single user install of MySQL, the following code should work: Acknowledgements Many thanks to Christoph M. Friedrich, John Heuer, Kurt Hornik, Torsten Hothorn, Saikat Debroy, Matthew Kelly, Brian D. Ripley, Mikhail Kondrin, Jake Luciani, Jens Nieschulze, Deepayan Sarkar","default_branch":null,"files":null,"tree":[],"storefront":"/r/r-dbi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/r-dbi/RMySQL/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}