Results 1 to 2 of 2

Thread: connecting to mysql from R

Hybrid View

  1. #1
    Join Date
    Nov 2005
    Beans
    43

    connecting to mysql from R

    Hello

    I've just installed R for the first time, along with DBI, Rmysql packages - all from package manager (using Kubuntu at the moment).

    I can't connect to mysql:

    Code:
    con1 <-dbConnect(MYSQL(), user="myname", password="mypassword", host="localhost", dbname="casualty")
    
     error in evaluating the argument 'drv' in selecting a method for function 'dbConnect': Error: could not find function "mysql"
    mysql is running. Is this this to do with the location of specific files?

    Many thanks

    Dave

  2. #2
    Join Date
    Nov 2005
    Beans
    43

    Re: connecting to mysql from R

    Update in case it's useful for anyone.

    1. Given up on Rmysql for now, as everything I turned up in searches indicates it's a little problematic for linux.
    2. But did successfully connect through RJDBC driver (ref here).

    Install libmysql-java from kubuntu package manager.
    Have DBI and RJDBC packages installed in R.
    Then
    Code:
    drv <- JDBC("com.mysql.jdbc.Driver", "/usr/share/java/mysql-connector-java-5.1.16.jar", identifier.quote="`")
     conn <- dbConnect(drv, "jdbc:mysql://localhost/mydbname", "myusername", "mypassword")

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •