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:

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