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]]