5

I am a novice in R. I am trying to connect to mySQL in R through RMyQL package. I am using the following command to connect to a sql server 

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

I am getting following error

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

What can be the possible reasons.The same SQl server is easily connecting in linux/

Improve this question
3
  • Have you tried the steps here: stackoverflow.com/questions/10292326/… Commented Mar 9, 2015 at 12:32
  • @felixmc the answers there are outdated - you can now get RMySQL directly from CRAN Commented Mar 12, 2015 at 11:12
  • The host should be something like "http://54.89.81.190", not the path to you phpmyadmin install. Commented Mar 12, 2015 at 11:13

1 Answer 1

Reset to default
0

Perhaps you should pass some values to another arguments of dbConnect: unix.socket and port, as described in dbConnect's documentation. These values can be accessed through phpinfo.php in your browser, as phpMyAdmin has modified MySQL file system and saved somewhere in its installation directory. For example, in Ubuntu default phpMyAdmin installation directory, the value of unix.socket could be: '/opt/lampp/var/mysql/mysql.sock' and 3306 for that of the port.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.