Dear R - users, I have 2 databases on a MySQL server. I am able to access the old one but not the freshly created one.
library(RMySQL) # This one is the old one, I am able to access it, > con1<- dbConnect(MySQL(),host= "myserver", db="db1", user= "user1",password > ="mypass1") # This is the new one. I am getting an error. > con2 <- dbConnect(MySQL(),host= "myserver", db="db2", user= > "user2",password="mypass2") Error in .local(drv, ...) : Failed to connect to database: Error: Access denied for user 'user2'@'myserver' (using password: YES) > Can someone please point me in the right direction? The error is not clear. I do not think I have mistyped the credentials. Many thanks, Ashim ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.