R MySQl Error connecting to Database

+1 vote

I'm new to the R language and what I'm doing is, I'm trying to connect to mySQL in R through RMyQL package. I'm using the below commands to do so:

ucscdb<-dbConnect(MySQL(),user="xxxx",password="xxxx",dbname="More",host="http://54.89.81.190/phpmyadmin/").

But i get the following error:

**Error in .local(drv, ...) : 
  Failed to connect to database: Error: Unknown MySQL Server Host 'http://54.89.81.190/phpmyadmin/' (11001)**

Dec 14, 2018 in Data Analytics by Tyrion anex
• 8,700 points
2,008 views

1 answer to this question.

0 votes

Check the dbConnect's documentation, you must pass values to another argument of dbConnect, unix.socket and port.

answered Dec 14, 2018 by Sophie may
• 10,620 points

Related Questions In Data Analytics

0 votes
1 answer

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

try this: library(RODBCext) sqlString <- "Select * from yourtable ...READ MORE

answered Nov 12, 2018 in Data Analytics by Maverick
• 10,840 points
2,820 views
+1 vote
1 answer

"Error in eval(ei, envir) : object 'RDX2' not found" when trying to source the code in R

This is a very common issue that ...READ MORE

answered Oct 30, 2018 in Data Analytics by Maverick
• 10,840 points
5,016 views
0 votes
1 answer

"Error in if" while trying to execute simple code in R

This caused non-logical data or missing values passed ...READ MORE

answered Oct 31, 2018 in Data Analytics by Kalgi
• 52,360 points
568 views
0 votes
1 answer
0 votes
1 answer

Error saying "Error in df$item : object of type 'closure' is not subsettable" when trying to use arules package

Try replacing ID <- c("A123","A123","A123","A123","B456","B456","B456") item <- c("bread", "butter", ...READ MORE

answered Nov 15, 2018 in Data Analytics by Maverick
• 10,840 points
1,621 views
+1 vote
1 answer
0 votes
1 answer

Is there a way to terminate an R program without causing an error?

You can make use of the 'browser' ...READ MORE

answered Jan 10, 2019 in Data Analytics by Sophie may
• 10,620 points
967 views
+1 vote
1 answer

R error: Unused arguments

 invoke REBMIX by trying this: REBMIX[[i, j, k]] ...READ MORE

answered Dec 14, 2018 in Data Analytics by Sophie may
• 10,620 points
6,351 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP