Open romoxml opened 7 years ago
Same issue, same sessionInfo.
The same, here
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!
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.
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
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")
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
You need to ask @krlmlr, he is maintaining DBI
and the master branch of RMySQL
.
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
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
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