[R] RMySQL system error: 10060

[Omayma Said]

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