#Install package
install.packages("RMySQL")
library(RMySQL)

#Create connection
mydb = dbConnect(MySQL(), user='user', password='password', dbname='database_name', host='host')

#Listing Tables from connection
dbListTables(mydb)

#Listing fields from table in connection
dbListFields(mydb, 'some_table')

#Executing queries (select, update, drop, etc.:
dbSendQuery(mydb, 'select * from sistema.acao;')

#Create table
dbWriteTable(mydb, name='table_name', value=data.frame.name)

#Retrieving data from MySQL:
rs = dbSendQuery(mydb, "select * from some_table")

#Fetch data to data.frame (-1 = all records)
data = fetch(rs, n=-1)