Hello,
I have access to my database via command line and through workbench, and
have access on the grant tables:
mysql> SELECT host,user,password,select_priv,insert_priv FROM user;
+------+-------+-------------------------------------------+-------------+-------------+
| host | user | password | select_priv
| insert_priv |
+------+-------+-------------------------------------------+-------------+-------------+
| % | adick | *D2D62126137364E6FDFD43E4887123C99C4C6B57 | Y
| Y |
| % | root | *D2D62126137364E6FDFD43E4887123C99C4C6B57 | Y
| Y |
+------+-------+-------------------------------------------+-------------+-------------+
2 rows in set (0.00 sec)
But when I run the following:
> library(RMySQL)
Loading required package: DBI
> drv = dbDriver("MySQL")
> con = dbConnect(drv, user="adick", password = "***",
dbname="***",
host="***")
Error in mysqlNewConnection(drv, ...) :
RS-DBI driver: (Failed to connect to database: Error: Access denied
for user 'adick'@'host' (using password: YES)
)
Further, this error is sporadic. For example, it ran successfully
yesterday afternoon. I have installed two MySQL databases on two
separate computers and am having the same problems. Tried restarting
computers/databases etc. Also, there are no limits to these users on
number of connections etc. I am completely stumped at this point.
R version 2.15.1 (2012-06-22) -- "Roasted Marshmallows"
Copyright (C) 2012 The R Foundation for Statistical Computing
ISBN 3-900051-07-0
Platform: x86_64-apple-darwin9.8.0/x86_64 (64-bit)
Anthony
--
Anthony Steven Dick, Ph.D.
Assistant Professor
Director, Developmental Science Program
Department of Psychology
Florida International University
Modesto A. Maidique Campus DM 296B
11200 S.W. 8th Street
Miami, FL 33199
Phone: 305-348-4202 (try this first)
Lab Phone: 305-348-9057 or 305-348-9055
Fax: 305-348-3879
Email: adick at fiu.edu
Webpage: http://www.fiu.edu/~adick
Lab Webpage: http://dcn.fiu.edu
