I have a project with a connection that was working properly on the same device. I usually work on two devices and pull my updates from a remote repo. I suddenly got the error below. However, I could connect from the same device through MySQL workbench.
I posted the on [Stackoverflow]( http://stackoverflow.com/questions/43073782/rmysql-system-error-10060) library(RMySQL) con <- dbConnect(RMySQL::MySQL(), host = "xxx", dbname="yyy", user = "zzz", password = "############") Error in .local(drv, ...) : Failed to connect to database: Error: Lost connection to MySQL server at 'reading authorization packet', system error: 10060 > sessionInfo() R version 3.3.1 (2016-06-21)Platform: x86_64-w64-mingw32/x64 (64-bit)Running under: Windows >= 8 x64 (build 9200) locale:[1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252 [3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C [5] LC_TIME=English_United States.1252 attached base packages:[1] stats graphics grDevices utils datasets methods base other attached packages:[1] RMySQL_0.10.10 DBI_0.4-1 loaded via a namespace (and not attached):[1] tools_3.3.1 [[alternative HTML version deleted]] ______________________________________________ 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.
