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