RMySQL system error: 10060

[romoxml]

This was originally posted on SO here:
http://stackoverflow.com/questions/43073782/rmysql-system-error-10060

I have a project with a connection that was working properly on the same device. I suddenly got the error below. And I could connect from the same device through MySQL workbench.

What could be the reason?
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

And here's the session info

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

[llayman]

Same issue, same sessionInfo.

[danielcamara]

The same, here

• Package RMySQL version 0.10.9
• MySQL 5.5

The solutions stated at http://stackoverflow.com/questions/5755819/lost-connection-to-mysql-server-at-reading-initial-communication-packet-syste, did not work. In any case I do manage to connect mysql via python, so the problem with mysql configuration (localhost/127.0.0.1) or firewall denying the access, should not be the problem!

[vinesh-raja]

Hi, the actual error is,

"Failed to connect to database: Error: Lost connection to MySQL server at 'reading authorization packet', system error: 10060"

I faced this issue with the version of R-3.3.3.
Solution: As a temporary measure, rolled back to R-3.1.3, and that solves the issue.

[K4uP]

Hi,

I have the same problem.

Here is my sessioninfo:

R version 3.3.2 (2016-10-31)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows >= 8 x64 (build 9200)

locale:
[1] LC_COLLATE=German_Germany.1252  LC_CTYPE=German_Germany.1252    LC_MONETARY=German_Germany.1252 LC_NUMERIC=C                    LC_TIME=German_Germany.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
 [1] RMySQL_0.10.11       DBI_0.6-1            reshape_0.8.6        tidyr_0.6.1          dplyr_0.5.0          lubridate_1.6.0      ggplot2_2.2.1        DT_0.2              
 [9] shinydashboard_0.5.3 shiny_1.0.2     

Error message:
Warning: Error in .local: Failed to connect to database: Error: Lost connection to MySQL server at 'reading authorization packet', system error: 10060

• Package RMySQL version 0.10.11

• MySQL 5.7

[jfrostad]

I was able to fix this issue on my PC using R 3.4 by following [@page's advice][https://stackoverflow.com/questions/43073782/rmysql-system-error-10060] to look into the package versioning. However, not only did I need to install an earlier version of RMySQL (reverting from 0.10.11 to 0.10.9), I also needed to change versions on its dependancy package DBI (reverting from 0.6-1 to 0.5), using the following command:

require(devtools)
install_version("DBI", version = "0.5", repos = "http://cran.us.r-project.org")
install_version("RMySQL", version = "0.10.9", repos = "http://cran.us.r-project.org")

[talithafs]

Thanks, @jfrostad : ) I was almost giving up on RMySQL. Turns out i also had to roll back DBI...

@jeroen, any news on this issue? RMySQL is crucial for my package, BETS, and users are not really comfortable with rolling back 2 packages after installing it. I might consider an alternative package, like RODBC, but I honestly prefer RMySQL

[jeroen]

You need to ask @krlmlr, he is maintaining DBI and the master branch of RMySQL.

[ShekharSahu]

Any updates on this? I have similar issues. I won't be able to rollback to the previous version of R or the package. @krlmlr