I think this is not an R issue, but one of MAMP. On my server's
sql service, I can connect using password, however, on my local
MAMP, I need the socket:
dbCon <- dbConnect(dbdr, user="root", password="root",
dbname="mydb",
unix.socket="/Applications/MAMP/tmp/mysql/mysql.sock")
HTH, *S*
On
The following worked for me recently:
library(RMySQL)
MySQL. <- MySQL()
MySQLcon <- dbConnect(MySQL., user='thisuser', password='thispassword',
dbname='desiredDB')
I have the following suggestions and questions for you:
1. Have you tried supplyi
Hello,
I used to use RMySQL but as there is no more package for windows, I decided
to move to RODBC.
I installed ODBC driver for MySQL (downloaded on the MySQL website) and then
the RODBC package.
I finally discovered that it was not needed to "register" your database with
ODBC before using it.
Folks,
1. can you pelase cite the messages you are repsonding to?
2. Can you please include the original poster of the question who is not
necessarily subscribed to the list?
Thanks,
Uwe Ligges
On 18.01.2011 09:52, Joel wrote:
You could try useing '127.0.0.1' instead of 'localhost' and see
You could try useing '127.0.0.1' instead of 'localhost' and see if that
works.
--
View this message in context:
http://r.789695.n4.nabble.com/Accessing-MySQL-Database-in-R-tp3221264p3221291.html
Sent from the R help mailing list archive at Nabble.com.
__
Hi:
Because R does not have a direct interface to MySQL?
You need to load a communication package - the two most common ones are
RODBC and RMySQL. The former requires that you register your MySQL database
table(s) with ODBC before using the RODBC package on them, whereas the
latter works with spe
I have a local installation of MySQL on my computer.
I enter the following to access MySQL from the command line:
/Applications/MAMP/Library/bin/mysql -h localhost -u root -p
I am then prompted for a password, and I use: root
This connects me to MySQL in the command line.
I now want to access My
7 matches
Mail list logo