R & MySQl : Error connecting to Database

0 votes

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,280 points
119 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 9,330 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,020 points
262 views
0 votes
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,020 points
264 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
• 36,420 points
21 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,020 points
66 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

R error: Unused arguments

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

answered Dec 13, 2018 in Data Analytics by Sophie may
• 9,330 points
522 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.