[R] RMySQL dbConnect issues

[Anthony Dick]

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