I'm new to MySQL and I installed this program to use with R. I was able to install the RMySQL library, following the tutorials I found on the internet and the course I'm doing at Coursera as
link and
I even tried to install an older RMySQL second library: link
Using the code:
require(devtools)
install_version("RMySQL", version = "0.10.9", repos = "http://cran.us.r-
project.org")
But none of this worked. When I went to test MySQL, connecting to MySQL from UCLA using the following command:
ucscDb <- dbConnect(MySQL(), user="genome", host="genome-mysql.cse.ucsc.edu")
The following error appeared:
Error in .local(drv, ...) :
Failed to connect to database: Error: Lost connection to MySQL server at
'reading authorization packet', system error: 10060
I believe this happened because of problems installing MySQL. Does anyone have any tips or suggestions?