[R] Connection problem to MySQL

[David Tudor]

Dear All,

What am I doing wrong?


 >library(DBI)
 > library(RMySQL)
 > mgr <- dbDriver("MySQL")
 > con <- dbConnect(mgr, host="http://localhost", dbname="marketing")
Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect 
(null)@http://localhost on dbname "marketing"
)
 > con <- dbConnect(mgr, host="http://localhost/", 
dbname="c:/mysql/data/marketing/")
Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect 
(null)@http://localhost/ on dbname "c:/mysql/data/marketing/"
)


I am running:
R1.7.0
php 4.3.0
MySQL 3.23.55
Windows XP 5.1.2600
Apache 1.3.27

Thank you very much for your help.

David Tudor
-------------- next part --------------

---