Error while connecting to mysql databse(remotely)

Hi All, I am trying to save my shiny app user data in mysql databse(remotely).
But when I am trying to establish a connection with the database, it's showing an error-
Error in .local(drv, ...) :
Failed to connect to database: Error: Unknown MySQL Server Host 'host_ip' (11001)

I am using-

mydb = dbConnect(MySQL(), user='user', 
                 password='pwd', dbname='db_name', host='host_ip')

shouldn't it be the ip of the database host and not a character string saying 'host_ip' ?

I don't know how to support you in trying to access a database that in principle I myself can't access.

No problem. Thanks. :slight_smile:

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

ok, that wasnt clear since you edited the error message.
can you confirm that you can successfully ping the ip you tried to use ? that the service is running and accepting queries etc?

I am using IP only. Just for confidentiality, I didn't copied here..

where is this function from ?

Yes. I can ping the same in browser and can access after user id and pwd.. And it is accepting the queries.

It's from RMySQL library.