R MySQl Error connecting to Database

Question

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)**

Answer 1

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