I can't connect RStudio with MySQL

#1

I can't connect a MySQL database with RStudio ... I have attached the code. I also made the connection with the ODBC connector on the pc.

library(RMySQL)
con <-odbcConnect("MySQLConnection2", uid="root", pwd="mineria1234*",dbname="empleados",host="localhost")
mysqltable <-sqlQuery(con,"SELECT*FROM new_table")

#2

Can you show the error message you are getting? Also, RMySQL is being deprecated in favor of RMariaDB

#3

...Hi Andres, thank you very much for answering. I didn't know about MySQL, would it be replaced by RMariaDB? Look Andrés, I changed the version of RStudio (to the previous one to the current one) and so far it is running well ...

#4

The RMySQL package is not under active development anymore because RMariaDB is intended to be its replacement, this is from the official GitHub repository:

NOTE: this package is being phased out in favor of the new RMariaDB package.

#5

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