The problem has been solved. I didnt install the mysql
libraries and header files properly.
To solve it, I installed:
MySQL-client-4.1.7-0.i386.rpm
MySQL-server-4.1.7-0.i386.rpm
AND
MySQL-devel-4.1.7-0.i386.rpm (libraries and header files)
then I installed RMySQL using:
export PKG_CPPFLAGS="-I/usr/include/mysql"
export PKG_LIBS="-L/usr/lib/mysql -lmysqlclient"
R CMD INSTALL -l /usr/local/lib/R RMySQL_0.5-5.tar.gz
thanks, Rudi.
On Thu, 28 Oct 2004 06:03:46 -0400
Sean Davis <[EMAIL PROTECTED]> wrote:
On Oct 28, 2004, at 4:37 AM, R.Alberts wrote:
Hi,
I cannot connect to my mysql database from within R
using RMySQL. What
am I doing wrong?
I use linux SuSe 8.1 and R-2.0.0
RMySQL_0.5-5.tar.gz
DBI_0.1-8.tar.gz
I get the following error in R:
library(RMySQL)
Loading required package: DBI
m <- dbDriver("MySQL")
m
<MySQLDriver:(1756)>
con <- dbConnect(m, group = "mygroup")
Error in mysqlNewConnection(drv, ...) : RS-DBI driver:
(could not
connect [EMAIL PROTECTED] on dbname "mydatabase")
On the mysql server, there is a user named myuser? The
password for this user is xxxxxx (or whatever)? The
database is called mydatabase? The host for the server
is localhost (mysql is running on the same machine as R)?
That user/password combination has access to mydatabase?
Can you connect from the mysql client on the same
machine with those settings?
Sean
______________________________________________
[EMAIL PROTECTED] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
