Unable to write in MYSQL

Hi Everyone, While writing the data in MYSQL through R, I am unable to do it as it is showing the below error.
could not run statement: Loading local data is disabled; this must be enabled on both the client and server sides

However, If I am using tableau prep to write the data in MYSQL with same credentials I am able to do it. I am also able to fetch the data through query for ET purpose.
Below is the code that I am using to write in DB.

dbWriteTable(mydb, name = "testtable", value = dataframe, row.names = FALSE, append=TRUE)

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

If you have a query related to it or one of the replies, start a new topic and refer back with a link.