Error saying Failed to connect to database Error Lost connection to MySQL server at handshake

Question

Hi I'm trying to connect R to a MySQL database by using the following code.

library(RMySQL) library(dbConnect) con<-dbConnect(dbDriver('MySQL'),user='root',password='pw',dbname='dbname',host='100.000.0.00')

R give back the following error:

Error in .local(drv, ...) : Failed to connect to database: Error: Lost connection to MySQL server at 'handshake: waiting for inital communication packet', system error: 138

Answer 1

try this:

library(RODBCext)
sqlString <- "Select * from yourtable or sql query ;"
dbhandle<- odbcDriverConnect('driver{SQLServer};server=Servername;database=databasename;trusted_connection=True')
data <- sqlExecute(dbhandle, sqlString, fetch = TRUE)