Thanks for your help. having MySQL server locally (or in some other place) should solve the configuration problem.
By the way, I should have written forgive, no forget. Forgive me. Jorge de la Vega -----Mensaje original----- De: bogdan romocea [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 18 de Marzo de 2005 01:11 PM Para: Uwe Ligges; De la Vega Góngora Jorge CC: r-help@stat.math.ethz.ch Asunto: Re: [R] Basic questions about RMySQL I certainly can't; I initially misunderstood the question. If connecting to MySQL is the problem, then you need to know the user ID, the domain and the password. Ask your DB administrator for help. Here's an example that works for me (local MySQL installation): require(DBI) require(RMySQL) MySQL(max.con = 16, fetch.default.rec = 5000, force.reload = F) drv <- dbDriver("MySQL") con <- dbConnect(drv,username="userid",password="pswd",dbname="db") dbListTables(con) --- Uwe Ligges <[EMAIL PROTECTED]> wrote: > bogdan romocea wrote: > > > 1. No way. You must have MySQL installed on your computer. > > > > 2. You must install the server. For details, see > > http://dev.mysql.com/doc/mysql/en/index.html . For portability, I > > would suggest that you run MySQL in the shell (ignore the GUIs) and > > save the syntax for adding users, creating > tables > > etc. This will likely take more time when you first do it, but if > you > > have to move to another computer later on, you can setup the new > MySQL > > installation very quickly and easily. > > Can you tell us any reason why the server should run on the same > machine R is running on? > > Uwe Ligges > > > > hth, > > b. > > > > > > -----Original Message----- > > From: De la Vega Góngora Jorge [mailto:[EMAIL PROTECTED] > > Sent: Friday, March 18, 2005 11:58 AM > > To: r-help@stat.math.ethz.ch > > Subject: [R] Basic questions about RMySQL > > > > > > Hello, > > > > Please forget me if I am asking something that is well documented. > I > > have read documentation but there are points that are not clear for > me. > > I am not expert in R nor Databases, but if someone direct me to a > > tutorial, I will appreciate it.. > > > > 1. In my understanding, I can install and use RMySQL withouth > having > > to install MySQL in my PC, to have access to and to create new > tables . > > Is this right? > > > > 2. I have created a c:\my.cnf file to access a database I have, > but > > withouth installing the server, where I can define the user, > password > > and host to establish a connection? > > > > Thanks in advance > > > > > > ------------------------------------------------------------------- > > Jorge de la Vega Gongora | Telefono: (525) 5268 8379 > > Investigador | Fax: (525) 5268 8481 > > Banco de Mexico | email: [EMAIL PROTECTED] > > Planeación y Programación de Emisión | web: > > http://www.stat.umn.edu/~jvega > > Calzada Legaria 691 Módulo IV | > > Col. Irrigación 11500 | > > > > ______________________________________________ > > R-help@stat.math.ethz.ch mailing list > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide! > > http://www.R-project.org/posting-guide.html > > > > ______________________________________________ > > R-help@stat.math.ethz.ch mailing list > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
